4 ms·

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

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.

contrahax 6y ago
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).
- dwwoelfel 6y ago
  > 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 https://cloud.google.com/sql/docs/postgres/upgrade-db
dragonwriter 6y ago
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/USER_UpgradeDBInstance.PostgreSQL.html https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...
Graphguy 6y ago
IBM Cloud lets you upgrade major versions through Read Replicas and also do dry runs, https://cloud.ibm.com/docs/databases-for-postgresql?topic=databases-for-postgresql-upgrading#upgrading-from-a-read-only-replica https://cloud.ibm.com/docs/databases-for-postgresql?topic=da...