2 ms·
> 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
by zozbot234 6y ago
> 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.
- 411111111111111 6y agoThat'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.