I've tried numerous things, and can't seem to get past an Exception while connecting when trying to connect to a Google Cloud PostgreSQL instance from my Google Cloud App Engine. This is probably t...

I'm facing the following situation: I have to do a logical replication of my Cloud SQL PostgreSQL instance to an external PostgreSQL database and vice-versa. More specifically, the CloudSQL and th...

I'm trying to export my database created in Google Cloud Sql and import it into a new external server. I tried to create a sql backup through the google console, downloaded it and copied it to the ...

Is there any guidance available to use Google Cloud SQL as a Dataflow read source and/or sink? At the Apache Beam Python SDK 2.1.0 documentation there isn't a chapter mentioning Google Cloud SQL. ...

I'm trying to setup a connection locally for 2nd generation cloud sql instance. Call for the proxy is ./cloud_sql_proxy -dir=/cloudsql -instances=status-1268:us-central1:status-dev=tcp:3306 &...

The number of connections for Google Cloud SQL PostgreSQL databases is relatively low. Depending on the plan this is somewhere between 25 and 500, while the limit for MySQL in Google Cloud SQL is b...

How to change the postgresql.conf parameter "max_connections" on Google Cloud SQL? When I exceed 100 connections I get the error: "FATAL: remaining connection slots are reserved for non-replicatio...

I have my google cloud project which is the firebase project where I created years ago 2018 then four days ago Nov 15, 2022 I created the Cloud SQL Instance Into the same project and after that it ...

We have created an app on App Engine using Datastore. Now we have been led to use Cloud SQL as we wanted to use joins, nested queries, and functions such as average, total etc. Data gets migr...

I have a PostgreSQL database deployed in Google Cloud that I am trying to connect to from a Cloud Run instance. I have tried the following two packages, both of them eventually leading to the same ...

I am trying to use pg_cron to schedule calls on stored procedure on several DBs in a Postgres Cloud SQL instance. Unfortunately it looks like pg_cron can only be only created on postgres DB When I ...

I'm developing an app that meant to run only in Israel. All of our tables contains times at Israeli time (Tel Aviv time). because the SQL in GCP doesn't support default timezone and time zone conv...

I have created simple app using Asp.NET Core. It uses entity framework and local database. I deployed my app to Google Cloud App Engine but honestly I have no idea what to do with my database. For ...

Google Cloud SQL only allows you to control the database root user password. I need to create a new user and limit his access to read-only, while maintaining the full privileged user. Is there a w...

I would like the ability to protect against the deletion of a cloud SQL instance. This seems like a good step to take to avoid actions from an angry employee or a regretful click.

Connecting to Cloud SQL using Python is not always straightforward. Depending on the context, sometimes you have to connect to a Unix domain socket, allow-list IP addresses for TCP connections, run...

I have created a mysql database on google cloud that I'd like to access from a separate node web application (also running on google cloud). I am testing the connection locally on my computer first...

I am trying to run SET session_replication_role = 'replica'; in a GCP Cloud SQL Postgres 9.6 instance, however I'm encountering this error ERROR: permission denied to set parameter "session_replica...

I've read all the docs on the Google Cloud SQL site, and I now understand how to created and manage Read Replicas, but I have not seen any information about how to use them, Does Google automatic...

I am designing a solution in which Google Cloud SQL will be used to store all data from the regular functioning of the app(kind of OLTP data). The data is expected to grow over time into pretty lar...

I am trying to run the following command gcloud beta sql instances create my_replica \ --master-instance-name=db-master01 \ --master-username=replication_user \ --master-password='replication_pass...

In my Composer Airflow DAGs, I have been using the CloudSqlProxyRunner to connect to my Cloud SQL instance. However, after updating Google Cloud Composer from v1.18.4 to 1.18.6, my DAG started to e...

I have created a Google Cloud Project MySQL database to use in conjunction with the Jdbc service provided by Google Apps Script. Everything went as planned with the connection. I am basically conne...

When connecting to the CloudSQL DB, you must provide the PostgreSQL configuration details (this makes sense). When getting the necessary address information from Google's configuration page, you ar...

I'm new to Google Cloud SQL and Pub/Sub. I couldn't find documentation anywhere about this. But another question's accepted and upvoted answer seems to say it is possible to publish a Pub/Sub messa...