News for hackers. Stuff that matters.
Re:PostgreSQL 13 by shay_ker on Thursday September 24, 2020 @11:50AM (#24579795)
Are there any PG providers that allow you to do a seamless upgrade, from, say, 12 -> 13? I know logical replication allows you to do this, but with some caveats. Curious what other people's experience is.
Re:PostgreSQL 13 by contrahax on Thursday September 24, 2020 @12:41PM (#24580533)
Aiven does this and usually has the updates available within two weeks of release. We've gone 10 -> 11 -> 12 seamlessly (and fully online).

GCP also has this, but it usually takes them a year or two to have newer versions of PG (and by that time they are already outdated).

Re:PostgreSQL 13 by dwwoelfel on Thursday September 24, 2020 @02:05PM (#24581541)
> GCP also has this

Are you saying that GCP has seamless upgrades? Any link to a doc? The only one I can find has you dump the database and restore it: https://cloud.google.com/sql/docs/postgres/upgrade-db

Re:PostgreSQL 13 by Graphguy on Thursday September 24, 2020 @03:52PM (#24582809)
IBM Cloud lets you upgrade major versions through Read Replicas and also do dry runs, https://cloud.ibm.com/docs/databases-for-postgresql?topic=da...
Re:PostgreSQL 13 by dragonwriter on Thursday September 24, 2020 @02:12PM (#24581630)
AWS supports relatively seamless (but not automatic) major version upgrades, though because the database engine may have backward compatibility issues they recommend (but don't require) you do a lot of steps which make it less-than-seamless but safer.

They don't try to automatically handle breaking changes for you.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...