pg_restore error - Mailing list pgsql-admin

From Düster Horst
Subject pg_restore error
Date
Msg-id 5B025B1F39D6D4119F5700508BEEEC66F94BF2@SRSOFAIOI4546
Whole thread Raw
List 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 by date:

Previous
From: Nageshwar Rao
Date:
Subject: calling a java program in a trigger
Next
From: "Lee Wu"
Date:
Subject: pg_ctl stop -m fast