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 [EMAIL PROTECTED] www.sogis.so.ch ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
