Thread: pg_restore error

pg_restore error

From
Düster Horst
Date:
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