Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux