from Hacker News

Cloud SQL for PostgreSQL now generally available

by CoachRufus87 on 4/18/18, 4:05 PM with 105 comments

  • by optimusclimb on 4/19/18, 2:22 AM

    Started down the path of using this when it was in beta, but had to abort when we saw there was no option to connect to it from Python App Engine Standard.

    Now that it's GA...it looks like that hasn't changed. Is the classic, Python, App Engine standard becoming a second class citizen? Or was there some reason why this wasn't considered GA worthy for Postgres?

    Trying to understand if going forward Google is trying to push everyone to the flexible environment or not - as I would have really expected connectivity between these two products.

  • by pritambarhate on 4/18/18, 9:14 PM

    Is point in time recovery available now in GA? I had checked it a couple of weeks ago for the beta service and it was not available. I think for a managed DB hosting point in time recovery is a critical feature.
  • by kdv on 4/18/18, 9:50 PM

    Does anyone have insight or experience using this in production? We're currently running PostgreSQL 10 w/ pg_partman on our own hardware but looking at a several options for cloud migration. Unfortunately, Citus Cloud on GCP doesn't appear to be an option (yet?)

    - Google Cloud SQL (PostgreSQL)

    - Citus Cloud (AWS Only)

    - Citus (managed ourselves) on GCP

  • by manigandham on 4/18/18, 8:02 PM

    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.
  • by zawerf on 4/18/18, 8:45 PM

    How do you deal with custom extensions (for example plv8)?

    I started off with heroku and they don't support the same subset:

    https://cloud.google.com/sql/docs/postgres/extensions

    https://devcenter.heroku.com/articles/heroku-postgres-extens...

  • by brightball on 4/18/18, 8:26 PM

    Will we be able to use the Citus extension? Been itching to get Citus running on GCP.
  • by eloff on 4/18/18, 8:30 PM

    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?
  • by theptip on 4/18/18, 8:42 PM

    Great news! This has been a long time coming (over a year since the beta started), looking forward to migrating my MySQL instances over.
  • by kerng on 4/18/18, 8:59 PM

    Great to see all three major cloud providers offering this now. Should be good for pricing!
  • by lobster_johnson on 4/18/18, 7:56 PM

    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.
  • by elvinyung on 4/18/18, 10:08 PM

    Postgres wire-compatible Spanner when? :P
  • by Lunatic666 on 4/19/18, 6:25 AM

    Last time I was at Google for a workshop (If you have the chance to visit Google, do it. The food alone is worth it), they didn’t seem to push CloudSQL a lot, because they wanted to guide people more in the spanner direction. Without a solid RDS counterpart however, I don’t think bigger companies will consider moving from AWS. Happy to see they changed their mind and continue to expand their SQL services. The competition by Google put a lot of pressure on AWS who seemed to be gotten a bit lazy. Google was ahead of the game with their global load balancers and network speed and quality. Now AWS countered with their 5th series C5/M5, which solve the bandwidth problem of the smaller C and M instances
  • by renchap on 4/18/18, 5:11 PM

    Finally! Nice to see more PG support. Any news about PostgreSQL 10 support?
  • by sirn on 4/19/18, 1:02 PM

    Since there seems to be some Googler who work on Cloud SQL here, I wonder is there any chance Cloud SQL will be available in asia-southeast1 soon? It's the only region (I believe) where Cloud SQL isn't available at all, and one of the main reasons we can't fully migrated from AWS to GCP just yet.
  • by cellis on 4/19/18, 4:54 AM

    I tried using this, but couldn't get the root certs to work. So I went to AWS RDS instead. A pity, it's much cheaper ( especially in beta pricing )
  • by foobarbazetc on 4/19/18, 12:45 AM

    Do these use the standard persistent disks (capped at 240mb/s)?
  • by TeeWEE on 4/18/18, 8:36 PM

    How expensive is this compared to, for example AWS RDS?