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:vishalonlist@gmail.com]
> Gesendet am: Freitag, 29. Oktober 2004 11:33
> An: Düster Horst
> Cc: pgsql-admin@postgresql.org
> 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
>
>