Re: fine tuned database dump/reload?

Douglas McNaught <doug@mcnaught.org> writes:
> Dan Armbrust <daniel.armbrust.list@gmail.com> writes:
>> Maybe I missed something then, because it didn't last time I tried to
>> move some data.  I had to drop my foreign keys before I could reload
>> it.

> What version was this?  Older versions definitely had some problems
> with table ordering.  In 8.0.X, the tables in the dump all get loaded
> before the FK constraints are created, and I have never seen a
> problem.

Even in current versions, you have to do a full (schema+data) dump for
it to work "right".  Data-only dumps are prone to FK problems.  This
is insoluble in the general case, though you can work around it to some
extent with the --disable-triggers option.

            regards, tom lane