Hallo I try to restore a large DB with BLOBS. I created the dump file with:
pg_dump -Fc -b <dbname> > dump.file During the restore process startet with the following command: pg_restore -d <dbname> dump.file the process breakes with the error message that a table couldn't be found. So I started the pg_restore in verbose mode. This mode offers the problem. pg_restore tries to create a view but a referenced table does not exists. I thought, that pg_restore will organize the restore-prozess in an optimal order. This seems not work correct!!?? I would be grateful to hear any hints. My system: Postgresql 7.4.5 SuSe 9.1 Linux With best regards Horst Düster ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
