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
--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com