Re: Backup strategy

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


On Wed, Feb 28, 2024 at 11:23 AM David Barron <david.barron@xxxxxxxxxx> wrote:

Good day all


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.

Clear, but, like Tom said, makes little sense.  

Why?  Lots of databases (including ours) have scads of foreign key constraints and triggers.  If pg_restore didn't "take that into account", people would have been hollering about that 20 years ago.

pg_restore works perfectly every time I restore the whole database.  

Thus... show a verbose whole database pg_dump and pg_restore, with error messages.

[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