In-reply-to » Familiarising myself with pgbackrest. Need to make sure this extended service outage isn't repeated.

[Why] not just simply:
pg_dump -F t DB_NAME > /backups/DB_NAME

Never found a more finicky format than pg_dump. Internet says dump and restore have to be the tools associated with the same release of the database, databases on the same version, of course; think that restore worked? Nah. This is my last hope now (pictured), as the jump from 32-bit to 64-bit means that my pgbackrest backups are ‘corrupt’ outta the gate.

Download

⤋ Read More