Re: pg_restore error - Mailing list pgsql-admin

From Vishal Kashyap @ [Sai Hertz And Control Systems]
Subject Re: pg_restore error
Date
Msg-id 77b69d21041029033267707641@mail.gmail.com
Whole thread Raw
In response to pg_restore error  (Düster Horst <Horst.Duester@bd.so.ch>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Düster Horst
Date:
Subject: pg_restore error
Next
From: Düster Horst
Date:
Subject: Re: pg_restore error