How we upgraded our 4TB Postgres database

Re:How we upgraded our 4TB Postgres database by burai on Tuesday April 19, 2022 @01:49PM (#31086408)

I used to work on a company that had MongoDB as the main database. Leaving a lot of criticism aside, the replicaset model for Mongo made the upgrades much easier than the ones in other type of databses.

[ Parent | on HN ]

Re:How we upgraded our 4TB Postgres database by stingraycharles on Tuesday April 19, 2022 @01:53PM (#31086455)

While that’s true, managed services on eg AWS provide hot replica’s as well, which you can use to upgrade the database and do a failover to the new version.

We actually migrated from vanilla Postgres to Aurora that way with minimal risk / downtime, it was a really smooth process.

[ Parent | on HN ]