| From: | Düster Horst <Horst(dot)Duester(at)bd(dot)so(dot)ch> |
|---|---|
| To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | pg_restore error |
| Date: | 2004-10-28 15:48:18 |
| Message-ID: | 5B025B1F39D6D4119F5700508BEEEC66F94BF2@SRSOFAIOI4546 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)duester(at)bd(dot)so(dot)ch
www.sogis.so.ch
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lee Wu | 2004-10-28 16:38:28 | pg_ctl stop -m fast |
| Previous Message | Nageshwar Rao | 2004-10-28 11:35:27 | calling a java program in a trigger |