Re: Backup strategy

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


David Barron <david.barron@xxxxxxxxxx> writes:
> I'm responsible for a couple of databases that have constraints and indexes on most, if not all, of the tables, which means that the tables have to be backed up and restored in the correct order to take the constraints into account.  But pg_dump and pg_restore don't take that into account, so when doing restores I was running into errors.  Hopefully that is clear.

Your statement is clear, but you have not provided any explanation of
*why* pg_dump fails to cope with your database.  It generally does
manage to handle foreign key constraints without help.

> The solution I found was to use the -section option with pg_dump, like this:

Splitting up the dump is frequently counterproductive, so I have a
feeling this isn't the best way to proceed.  In any case, --section
still emits all the same items in the same order, so it's not really
likely to fix problems.  Probably what masked the issue is your
use of --disable-triggers.

			regards, tom lane

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux