pg_restore error

Поиск
Список
Период
Сортировка
От Düster Horst
Тема pg_restore error
Дата
Msg-id 5B025B1F39D6D4119F5700508BEEEC66F94BF2@SRSOFAIOI4546
обсуждение исходный текст
Список pgsql-admin
Hallo

I dumped a database with large objects with the command pg_dump -Fc -b
dbname > dbname.dmp

To restore the DB I use pg_restore -d newdb dbname.dmp.
The restore process breakes with the following error message:

pg_restore: [archiver (db)] could not execute query: ERROR: relation
"tablename" does not exist.

I'm a little bit confused about that, because I thought that this error
could not happen, due to pg_restore seems to generate the items in an
optimal order. Isn't it??

I appreciate for any hints.

With best regards.

Dr. Horst Düster
GIS-Koordinator

Kanton Solothurn 
Amt für Geoinformation
Abteilung SO!GIS Koordination
Werkhofstr. 65
CH-4509 Solothurn

Tel.: ++41 (0)32 627 25 32
Fax: ++41 (0)32 627 22 14

horst.duester@bd.so.ch
www.sogis.so.ch


В списке pgsql-admin по дате отправления:

Предыдущее
От: Nageshwar Rao
Дата:
Сообщение: calling a java program in a trigger
Следующее
От: "Lee Wu"
Дата:
Сообщение: pg_ctl stop -m fast