Earlier quoted context omitted.
I just started using Google Cloud SQL – the allure of a managed Postgres service was strong. Can you share some of your experiences with it?
Sure. - No way to upgrade major postgres version without full export and import into new cluster. - Incredible delay between postgres versions. IIRC, it took nearly 2 years for them to add postgres 11 after it was released. - HA is basically useless. Costs double, still has 4-5 minute window of downtime as it fails over, doesn't avoid maintenance window downtime (both primary/standby have same maintenance window) and…
Things that seem similar in AWS:
- For major version upgrades, you need to bring up a new instance from a snapshot and catch it up with replication.
- HA failover results in a few minutes of downtime. (They claim using their SQL proxy will reduce this.)
- Lag in providing the latest Postgres versions. GCP seems to be a bit ahead of AWS here.
Is there a managed Postgres offering that you prefer? Aiven looks nice, feature-wise.