News for hackers. Stuff that matters.

A comment on Updating a 50 terabyte PostgreSQL database (2018). Parent comment

Re:Updating a 50 terabyte PostgreSQL database (2018) by zozbot234 on Monday March 22, 2021 @12:12PM (#26542807)
> Sadly, PostgreSQL doesn't have a built-in solution for online upgrade yet.

Surely you could just set up a logically-replicated standby server running the new PG version and then hot-failover to the standby, turning it into the new master. That should preserve availability throughout the upgrade.

[ Parent | on HN ]
Re:Updating a 50 terabyte PostgreSQL database (2018) by 411111111111111 on Monday March 22, 2021 @12:55PM (#26543391)
That's how they did it in 2015. Read the article if you want to know why they decided to change this in 2018.

Changing master for upgrades works great if youre not at their scale though.

[ Parent | on HN ]