A powerful dump utility - Mailing list pgsql-general

From Andrey Mosienko
Subject A powerful dump utility
Date
Msg-id 3E36117C.1255644B@feo.org.ru
Whole thread Raw
Responses Re: A powerful dump utility
List pgsql-general
Hello!


Is there an utility to dump PosgreSQL database with possibility to set order of
tables?

I have a situation when one of my tables was created with constraint check depending on
another table. But when I do dump, my dependable table dumped first, and then when I
restore my database it fails to load my data because of constraint check.

I wrote my own script and first I dump schema of my database and then all tables in
order I want. But dump of databse schema doesn't include:

SELECT setval ('"vl_id"', 198, true);

to setup my sequences well.

So are there any possibilities to solve my problem?

--
Best regards Andrey Feofilactovich.
e-mail: feo@ttn.ru, feo@feo.org.ru
ICQ: 28073807

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: all backends (pg7.2.3 / redhat 7.2) die due to unexpected signal 14 (SIGALRM)
Next
From: Jason Hihn
Date:
Subject: Using RSYNC for replication?