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.
[ Parent
| on HN ]
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).
> 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
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...