From: | Tino Schwarze <postgresql(at)tisc(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_dump/pg_restore |
Date: | 2008-04-08 20:44:01 |
Message-ID: | 20080408204401.GC30442@easy2.in-chemnitz.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-04-08 21:30:05 | Re: pg_dump/pg_restore |
Previous Message | Sergio Gabriel Rodriguez | 2008-04-08 19:52:23 | pg_dump/pg_restore |