On Tue, Apr 08, 2008 at 04:52:23PM -0300, Sergio Gabriel Rodriguez wrote: > I'm using postgresql 7.4, I have a problem with pg_dump/pg_restore. I > want to back and restore only one schema from my db (I did it), but > when I restore it, postgresql found errors in some views, this ones > needs of others which can't be found because the script will generate > them later. How can I make an orderer sql dump???
A quick fix would be to just restore the dump multiple times - everything which already exists will be skipped, the rest will be loaded. Repeat until everything is fine. ;-) Hope that helps, Tino. -- „Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma Gandhi) www.craniosacralzentrum.de www.forteego.de -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
