Re: import *.backup-file (PostGIS - not mine) - Mailing list pgsql-general

From gipsy-king1
Subject Re: import *.backup-file (PostGIS - not mine)
Date
Msg-id 1339481797687-5712158.post@n5.nabble.com
Whole thread Raw
In response to Re: import *.backup-file (PostGIS - not mine)  (Stefan Tzeggai <tzeggai@wikisquare.de>)
Responses Re: import *.backup-file (PostGIS - not mine)
List pgsql-general
There are few errors after my pg_restore command.

pg_restore -i -h localhost -p 5432 -U postgres -d THS -v
"H:.../netzknotenmodell_etrs89.backup"
could not execute query: ERROR:  type "public.geometry" is only a shell
could not execute query: ERROR:  relation "strasse.netzknotenmodell_etrs89"
does not exist
could not execute query: ERROR:  relation "netzknotenmodell_etrs89" does not
exist
could not execute query: ERROR:  relation "netzknotenmodell_etrs89" does not
exist
could not execute query: ERROR:  relation "netzknotenmodell_etrs89" does not
exist

pg_restore -i -h localhost -p 5432 -U postgres -d THS -v
"H:.../fahrbahnflaeche_etrs89.backup"
could not execute query: ERROR:  type "public.geometry" is only a shell
could not execute query: ERROR:  relation "strasse.fahrbahnflaeche_etrs89"
does not exist
could not execute query: ERROR:  relation "fahrbahnflaeche_etrs89" does not
exist
could not execute query: ERROR:  relation "fahrbahnflaeche_etrs89" does not
exist
could not execute query: ERROR:  relation "fahrbahnflaeche_etrs89" does not
exist

pg_restore -i -h localhost -p 5432 -U postgres -d THS -v
"H:.../strassenabschnitte_etrs89.backup"
could not execute query: ERROR:  type "public.geometry" is only a shell
could not execute query: ERROR:  relation
"strasse.strassenabschnitte_etrs89" does not exist
could not execute query: ERROR:  relation "strassenabschnitte_etrs89" does
not exist
could not execute query: ERROR:  relation "strassenabschnitte_etrs89" does
not exist
could not execute query: ERROR:  relation "strassenabschnitte_etrs89" does
not exist

pg_restore -i -h localhost -p 5432 -U postgres -d THS -v
"H:.../strassennetzmodell_etrs89.backup"
could not execute query: ERROR:  type "public.geometry" is only a shell
could not execute query: ERROR:  relation
"strasse.strassennetzmodell_etrs89" does not exist
could not execute query: ERROR:  relation "strassennetzmodell_etrs89" does
not exist
could not execute query: ERROR:  relation "strassennetzmodell_etrs89" does
not exist
could not execute query: ERROR:  relation "strassennetzmodell_etrs89" does
not exist

I got the same errors when I used the "-Fc".

Do you with your experience know whats's to do with these 4 backup-files or
which command is to use?

best regards
Thomas

--
View this message in context: http://postgresql.1045698.n5.nabble.com/import-backup-file-PostGIS-tp5712030p5712158.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Stefan Schwarzer
Date:
Subject: Problem installing extensions on Lion
Next
From: Tom Lane
Date:
Subject: Re: import *.backup-file (PostGIS - not mine)