Cloud SQL for PostgreSQL now generally available

#1

Post by CoachRufus87 » Wed, Apr 18, 2018, 4:05 PM UTC

Cloud SQL for PostgreSQL now generally available
cloudplatform.googleblog.com

Re: Cloud SQL for PostgreSQL now generally available

#2

Post by renchap » Wed, Apr 18, 2018, 5:11 PM UTC

Finally! Nice to see more PG support. Any news about PostgreSQL 10 support?

Re: Cloud SQL for PostgreSQL now generally available

#3

Post by briffle » Wed, Apr 18, 2018, 5:30 PM UTC

renchap wrote: post #2

Finally! Nice to see more PG support. Any news about PostgreSQL 10 support?

I asked that yesterday in a meeting with my gcloud rep, they said all work has gone into getting to GA, and once that is done, look for them to start doing things like updating, more new features, etc.

Re: Cloud SQL for PostgreSQL now generally available

#4

Post by [deleted] » Wed, Apr 18, 2018, 6:53 PM UTC

briffle wrote: post #3

renchap wrote: post #2

Finally! Nice to see more PG support. Any news about PostgreSQL 10 support?

I asked that yesterday in a meeting with my gcloud rep, they said all work has gone into getting to GA, and once that is done, look for them to start doing things like updating, more new features, etc.

[deleted]

Re: Cloud SQL for PostgreSQL now generally available

#5

Post by lobster_johnson » Wed, Apr 18, 2018, 7:56 PM UTC

Has anyone used the beta and got any feeling for how maintenance downtime impacts things? A bit nervous about how you can only set a "maintenance window" and not be able to plan ahead for disruption; as far as I can tell, they won't even tell you ahead of time. The HA seems really solid (zero-lag "regional disks"), but it's still a bit disconcerting.

Re: Cloud SQL for PostgreSQL now generally available

#6

Post by manigandham » Wed, Apr 18, 2018, 8:02 PM UTC

We actually just migrated off yesterday... we went with an independent vendor like Aiven instead of the clouds because they move too slowly and don't have enough features.

Re: Cloud SQL for PostgreSQL now generally available

#7

Post by manigandham » Wed, Apr 18, 2018, 8:20 PM UTC

lobster_johnson wrote: post #5

Has anyone used the beta and got any feeling for how maintenance downtime impacts things? A bit nervous about how you can only set a "maintenance window" and not be able to plan ahead for disruption; as far as I can tell, they won't even tell you ahead of time. The HA seems really solid (zero-lag "regional disks"), but it's still a bit disconcerting.

There is disruption yes. It's usually short however we always see retries in our logs for a few minutes. Our app doesn't need perfect uptime though and we haven't tried the HA setup.

Re: Cloud SQL for PostgreSQL now generally available

#8

Post by brightball » Wed, Apr 18, 2018, 8:26 PM UTC

Will we be able to use the Citus extension? Been itching to get Citus running on GCP.

Re: Cloud SQL for PostgreSQL now generally available

#9

Post by ciguy » Wed, Apr 18, 2018, 8:29 PM UTC

lobster_johnson wrote: post #5

Has anyone used the beta and got any feeling for how maintenance downtime impacts things? A bit nervous about how you can only set a "maintenance window" and not be able to plan ahead for disruption; as far as I can tell, they won't even tell you ahead of time. The HA seems really solid (zero-lag "regional disks"), but it's still a bit disconcerting.

Unfortunately last time I used CloudSQL for MySQL it was incredibly unstable. They would take down our master AND standby at the same time for maintenance. When we filed a ticket they just said it was a known bug with no plans to fix.

A major client of mine migrated to AWS because of this and other issues.

Re: Cloud SQL for PostgreSQL now generally available

#10

Post by eloff » Wed, Apr 18, 2018, 8:30 PM UTC

I'm looking around for more details on these "regional" disks that replicate between two zones at the block level. Is that just a fancy term for os level mirrored disks using the cloud persistent disks?