google-cloud-sql Questions

4

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...
Harrietharriett asked 10/10, 2018 at 22:1

2

I am investigating a few slow queries and I need some help reading the data I got. We have this one particular query which uses an index and runs pretty fast most of the time, however from time to...
Stortz asked 5/11, 2019 at 17:24

4

Solved

I have been able to successfully create a Google Container Cluster in the developers console and have deployed my app to it. This all starts up fine, however I find that I can't connect to Cloud SQ...

6

What ways do we have available to connect to a Google Cloud SQL (MySQL) instance from the newly introduced Google Cloud Composer? The intention is to get data from a Cloud SQL instance into BigQuer...

2

Solved

The docs describe that hasura needs the postgres connection string with the HASURA_GRAPHQL_DATABASE_URL env var. Example: docker run -d -p 8080:8080 \ -e HASURA_GRAPHQL_DATABASE_URL=postgres://u...
Ashok asked 13/10, 2019 at 8:36

1

Solved

I have an instances PostgreSQL 11 on production of a web application. Now, i want to modify the connectivity part to use internal IP and disable the public connection. Do this activity make a littl...

2

I'm new to Terraform, and I want to create a schema for the postgres database created on a PostgreSQL 9.6 instance on Google cloud SQL. To create the PostgreSQL instance I have this on main.tf: ...
Plowshare asked 14/10, 2019 at 21:51

4

Solved

I'm not sure what else I'm missing here, but my application is failing on start with: Message : The connection attempt failed. at org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUti...
Megganmeggi asked 5/10, 2019 at 21:25

2

Solved

Main Issue I'm unable to execute the function SELECT pg_stat_statements_reset(); in order to profile changes in query optimization due to insufficient permissions. The error message reads: permiss...
Pallaton asked 8/11, 2018 at 3:1

2

I am receiving an error which looks like this (in my functions log) Access denied for user \'varun_admin\'@\'cloudsqlproxy~84.117.112.32\' (using password: YES)', sqlMessage: `\'varun_admin\'@\'cl...

2

Solved

Since Google Cloud SQL for PostgreSQL doesn't give us a superuser (not even the postgres user), I can't see what queries other sessions are running from pg_stat_activity, nor can I terminate other ...
Stopoff asked 11/6, 2018 at 21:25

3

I'm trying to set up Metabase on a gcloud engine using Google Cloud SQL (MySQL). I've got it running using this git and this app.yaml: runtime: custom env: flex # Metabase does not support horiz...
Soybean asked 11/4, 2018 at 15:14

2

Solved

According to the Google Cloud Platform SQL docs, I should be able to both export to and import from sharded files in a GCS bucket by putting a * in the filename. If I import a single file, it work...
Kerrykersey asked 3/5, 2019 at 10:7

6

We are using Google Cloud Sql Second Generation with our AppEngine application. However today we've discovered some problem, we cannot insert emoji characters to our database because we cannot chan...
Thereby asked 10/8, 2016 at 14:54

1

I've being trying to create a new CloudSQL instance with a private IP attached from the get go. The only thing documentation hints me is to add a VPC network. I'm trying to add the default one. Fi...

5

I'm trying to use Google Cloud SQL over SSL from GCE(Google Compute Engine) instance. My problem is that I cannot connect to Cloud SQL instance over SSL. mysql command works normally. I can connec...
Mayfair asked 8/4, 2016 at 6:34

2

Solved

gcloud beta run deploy used to work but now I'm getting an error: $ gcloud beta run deploy $PROJECT --image $IMAGE_NAME --platform=managed --region us-central1 --project $PROJECT --add-cloudsql-in...
Kirkman asked 29/6, 2019 at 14:31

1

Solved

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 Projec...

1

The GCF Cloud SQL documentation does not show how to connect via the socket using SSL. Here is my config, however when I try to connect I get an ECONNREFUSED error. But when I try to connect to a n...
Tufthunter asked 19/6, 2019 at 9:0

3

Solved

I am using Google Cloud Platform to create a Django based http API, which uses Google's cloud SQL API and Machine Learning API. I made a django-mysql app on my pc and is able to test it successful...
Allwein asked 28/6, 2017 at 15:46

2

Solved

does anyone know how to connect to Google Cloud SQL from Sequelize? sequelize = new Sequelize(process.env.TEST_DB || 'postgres', 'blah', null, { dialect: 'postgres', operatorsAliases: Sequelize...
Hanni asked 22/9, 2018 at 9:52

1

I'm writing a script to orchestrate a Google Cloud SQL instance using the gcloud SDK. The SDK has a connect command, which takes a username but the password has to be entered at the prompt -...
Knockwurst asked 14/5, 2019 at 9:15

3

Solved

I've followed the steps at https://cloud.google.com/sql/docs/mysql/connect-kubernetes-engine to set up MySQL user accounts and service accounts. I've downloaded the JSON file containing my credenti...

1

Solved

I'm trying to connect postgreSQL instance in cloud SQL to my pgAdmin. And I'm totally confused. How can i do that?
Increate asked 30/4, 2019 at 16:32

3

I'm very new to Google Cloud and running applications in general. I currently have a Django app running in a Docker container on Google Flexible App Engine that connects to a Google Cloud SQL (Post...

© 2022 - 2024 — McMap. All rights reserved.