Re: import *.backup-file (PostGIS - not mine)

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.