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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html