Обсуждение: pg_dump/pg_restore

Hi for all, first sorry for my english is not good.

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???

I hope you can understand me :-).


Sergio Rodríguez (Argentina)

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

"Sergio Gabriel Rodriguez" <sgrodriguez@gmail.com> writes:
> 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???

Switch to a newer PG version.  If memory serves, 8.0 was the first
version in which pg_dump paid attention to dependencies rather than just
the order of original creation of views.  In 7.x it wasn't hard to
cause problems by doing CREATE OR REPLACE VIEW.

            regards, tom lane

On Tue, Apr 08, 2008 at 04:52:23PM -0300, Sergio Gabriel Rodriguez wrote:
> needs of others which can't be found because the script will generate
> them later. How can I make an orderer sql dump???

Use the custom format, use pg_restore to get the catalogue, and then edit
that catalogue to re-order the restore..

A