Stack Overflow
Stack Overflow

Questions tagged [google-cloud-sql]

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that live in Google's cloud. It is a fully-managed service that maintains, manages, and administers your databases, allowing you to focus on your applications and services.

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that live in Google's cloud. It is a fully-managed service that maintains, manages, and administers your databases, allowing you to focus on your applications and services.

Intro and features

Developer documentation

FAQ

3725 questions
16
votes
4 answers

Google Cloud SQL Postgres, when will PG 10 be available?

I am planning on moving our main project to Postgres 10 at some point. I like to keep the local dev's database version close to what we are running on prod. Currently our prod database is on Google Cloud SQL PostgreSQL 9.6. I have not heard…
xDTim
  • 161
  • 1
  • 3
16
votes
2 answers

Can't import PostgreSQL10 dump into 9.6 database

I need to somehow convert a v10 dump file into one which is 9.6 compatible Google's Cloud SQL runs PostgreSQL version 9.6 and my database has been running on version 10 since its creation. THE ISSUE: When trying to import the database into Cloud…
jenks
  • 383
  • 1
  • 3
  • 11
16
votes
9 answers

Google cloud sql instance super privilege error

I am very new in Google app engine please help me to solve my problem I have created one instance in Google cloud sql when I import SQL file then it shows me error like this. ERROR 1227 (42000) at line 1088: Access denied; you need (at least one…
ketan110
  • 171
  • 1
  • 1
  • 6
16
votes
4 answers

Google Cloud SQL "Idling IP Address"

I have been looking at the console’s billing as far as Cloud SQL and the VM Instance is concerned. I see that a lot of the cost comes from the idling hours of the Cloud SQL IP address. I am unsure as to where the settings are for this as i have…
superuserdo
  • 1,637
  • 3
  • 21
  • 33
15
votes
1 answer

Incorrect Service Networking config for instance: xxxx:SERVICE_NETWORKING_NOT_ENABLED

I'm trying to replicate a SQL instance in GCP via terraform. The active instance has a public IP, however subnets from a secondary project are shared with the project hosing the SQL instance, and the SQL instance is associated with the secondary…
NealR
  • 10,189
  • 61
  • 159
  • 299
15
votes
1 answer

Accessing Cloud SQL from another GCP project

I want to connect to Cloud SQL from a different GCP project. Cloud SQL is location in ProjectSQL and a VPC network is there in ProjectSQL project with name sql_vpc There is another project ProjectDataflow and this has a vpc dataflow_vpc. I want to…
Deepak Verma
  • 653
  • 1
  • 10
  • 24
15
votes
1 answer

GCP SQL Postgres problem with privileges : can't run a query with postgres user with generated symfony db

I am struggling to solve this problem with Google Cloud Platform's Cloud SQL component. My tech stack consists of hosting my application in a Google Kubernetes Engine (GKE) deployment, using the Cloud SQL proxy sidecar to connect to the database…
Alessandro Candon
  • 543
  • 2
  • 6
  • 21
15
votes
6 answers

Google Cloud SQL import - ERROR: HTTPError 403: The client is not authorized to make this request

I trying to import a database stored in the Cloud Storage using the command: gcloud sql instances import instance-name gs://connect-to-the-cloud-sql.appspot.com/my-cloud-sql-instance-backup But, I am getting error: ERROR:…
Beginner
  • 1,202
  • 2
  • 20
  • 29
15
votes
8 answers

Getting notAuthorized error with cloud_sql_proxy locally

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 & mysql -u status_stg --host 127.0.0.1 I am a bit unclear…
georges
  • 223
  • 1
  • 2
  • 9
14
votes
3 answers

Google CloudSQLAdmin - The service account does not have the required permissions for the bucket

I am writing a python function which uses service account credentials to call the Google cloudSQLAdmin api to export a database to a bucket. The service account has been given project owner permissions, and the bucket has permissions set for…
Lucy Nunley
  • 141
  • 1
  • 1
  • 4
14
votes
1 answer

Google Cloud SQL Postgres - randomly slow queries from Google Compute / Kubernetes

I've been testing Google Cloud SQL with Postgresql, but I have random queries taking ~3s instead of a few ms. Troubleshooting I did: The queries themselves aren't problems, rerunning the same query will work. Indexes are properly set. The…
Michael Villar
  • 289
  • 1
  • 6
14
votes
7 answers

Cloud SQL Proxy error - An attempt was made to access a socket in a way forbidden by its access permissions

This is the error that comes up when I try to use Cloud SQL Proxy to configure access to Google Cloud SQL in windows - "listen tcp 127.0.0.1:3306: bind: An attempt was made to access a socket in a way forbidden by its access permissions." This is…
opensourced101
  • 179
  • 1
  • 1
  • 8
14
votes
2 answers

GAE DataStore vs Google Cloud SQL for Enterprise Management Systems

I am building an application that is an enterprise management system using gae. I have built several applications using gae and the datastore, but never one that will require a high volume of users entering transactions along with the need for…
MindWire
  • 3,969
  • 7
  • 34
  • 46
13
votes
3 answers

ERROR: (gcloud.sql.connect) HTTPError 400: The incoming request contained invalid data

Problem I am not able to connect to my Cloud SQL postgres instance with the command line, which has been working previously: gcloud sql connect --user= This is the error I'm getting: ERROR: (gcloud.sql.connect) HTTPError…
Daniel Olsson
  • 698
  • 1
  • 6
  • 18
13
votes
5 answers

Retrieving Automated Google Cloud SQL Backups

My team has a requirement that we be able to retrieve a backup of our database (hosted on Google Cloud SQL) and restore that database to a locally hosted instance of MySQL. I know that Google Cloud SQL has the ability to schedule backups, but these…
Tombatron
  • 1,567
  • 1
  • 13
  • 27
1 2
3
…
99 100