3 ms·

I need to run Postgres in production soon. I've used AWS RDS (MySQL) in the past, but am also considering Google Cloud SQL. Things that seem similar in AWS:

I need to run Postgres in production soon. I've used AWS RDS (MySQL) in the past, but am also considering Google Cloud SQL. 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.

stevencorona 6y ago
To clarify, it’s a lot more work than bringing up a snapshot. You need to do a full export as SQL and reimport as SQL. Super annoying, slow, and requires hard downtime. Am using SQL proxy but doesn’t do much re: HA. I don’t know, I’ll probably just run my own Postgres at some point. The only peace of mind that I get from Cloud SQL is the automatic backups.