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.
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).
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
They don't try to automatically handle breaking changes for you.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...