Hi,
Try "pg_restore -l" to generate a TOC. You may rearrange the TOC file. Then use "pg_restore -L".
Hope it helps, Janko Richter
Düster Horst wrote:
Vishal
Thank you for your answer. My problem is, I have to restore BLOBS. The documentation says, it's only possible to restore blobs with pg_restore in one part. The way you suppose does not work with BLOBS because the restauration of single objects will not restore BOLBS.
Horst Düster
-----Ursprüngliche Nachricht----- Von: Vishal Kashyap @ [Sai Hertz And Control Systems] [mailto:[EMAIL PROTECTED] Gesendet am: Freitag, 29. Oktober 2004 11:33 An: Düster Horst Cc: [EMAIL PROTECTED] Betreff: Re: [ADMIN] pg_restore error
Hi
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.
pg_restore does not priortize till now idealy it must be like restoring the functions >> tables >> views >> seqences so on...
This is in the todo
http://developer.postgresql.org/todo.php
but for mean while you would have to use pg_restore to restore the tables one by one and then let other thing go on.
moreover if your database is not to large its best to make a text file of the dump and run it through psql
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
