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

Поиск
Список
Период
Сортировка
От gipsy-king1
Тема Re: import *.backup-file (PostGIS - not mine)
Дата
Msg-id 1339481797687-5712158.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: import *.backup-file (PostGIS - not mine)  (Stefan Tzeggai <tzeggai@wikisquare.de>)
Ответы Re: import *.backup-file (PostGIS - not mine)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Stefan Schwarzer
Дата:
Сообщение: Problem installing extensions on Lion
Следующее
От: Tom Lane
Дата:
Сообщение: Re: import *.backup-file (PostGIS - not mine)