Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [google-cloud-sql]

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that operate from Google's Cloud Platform.

Google Cloud SQL is a service that allows you to create, configure, and use relational databases that operate from Google's Cloud Platform.

133 questions
1
vote
2 answers

Google Cloud - Hipaa Compliance - PgAudit vs IAM Audit Logs

Our infrastructure is hosted on Google Cloud and uses postgresql instances via Cloud SQL I need to configure logging for HIPAA compliance. I have read 2 articles from Google's…
Shawn Northrop
  • 113
  • 6
1
vote
1 answer

Keycloak install with helm on GKE with Cloud SQL (external) database

I'm trying to install keycloak on GKE cluster in GCP with external database, i.e. CloudSQL postrges db. I want to use helm to install it, so: helm repo add bitnami https://charts.bitnami.com/bitnami I've downloaded Values.yml file from bitnami…
Michał Z
  • 11
  • 2
1
vote
1 answer

Google Cloud SQL connectivity from External network

We have a requirement to directly load Cloud SQL postgres tables from On-premise server ETL solutions. What would be the recommended and secure way of doing this without migrating the ETL solution to Google cloud? Please advise. Can/should Cloud…
Bijil Raj
  • 11
  • 1
1
vote
0 answers

How to connect two service producer networks in GCP?

I am using two google managed services i.e Google Cloud SQL and Google Cloud Data Fusion. The cloud data fusion private IP instance is deployed inside a google managed VPC(Let's call it A) which is peered with my custom VPC(Lets Call it B). Now my…
Piyush Sinha
  • 11
  • 1
1
vote
2 answers

How to setup multiple Google Cloud SQL-instances behind one set of firewall rules?

Currently we are running multiple MySQL servers in an off-site datacenter, these servers receive connections from multiple webservers, as well as connections from 20 to 30 users from their homes, with local installed apps. The database servers are…
Nhz
  • 11
  • 2
1
vote
0 answers

Unable to connect to CloudSQL from GKE without CloudSQL Proxy - SQLSTATE[HY000] [2002] Operation timed out

I have GKE cluster created with following command: gcloud container clusters create stage1 \ --enable-ip-alias \ --release-channel stable \ --zone us-central1 \ --node-locations us-central1-a,us-central1-b Now I wanted to connect my PHP application…
Tech User
  • 23
  • 3
1
vote
1 answer

Setting password for MySQL root user in CLoudSQL with private IP address

How to change the password for MySQL root user in GCP CloudSQL DB instance with private IP address . I am able to change the password using the below command from Cloud Shell with Public IP gcloud sql users set-password root --instance=testdb…
Zama Ques
  • 523
  • 1
  • 9
  • 24
1
vote
3 answers

Permission issues in cloudSQL SQL Server (GCP)

I see permission error when i tried to shrink files/db in CloudSQL sql server. I know its a managed service and do not have sa user and super privileges. But is there any similar user like sa (or) alternate ways to carry out such tasks. enter image…
Dothertechie
  • 21
  • 4
1
vote
1 answer

Create tablespace in gcloud sql instances

I had created one PostgreSQL instance under gcloud database. Using default user (postgres) i want to create a tablespace but its not allowing me to create, says permission doesn't exist Can we create custom tablespaces with gcloud database instances…
saikiran
  • 11
  • 2
0
votes
1 answer

How to connect to Postgres Cloud Sql without public IP from Cloud Run

There is a documentation on the Cloud SQL for Cloud Run connection(https://cloud.google.com/sql/docs/postgres/connect-run), but it contains the following line: Note: These instructions require your Cloud SQL instance to have a public IP address…
ruslash
  • 103
  • 3
0
votes
1 answer

Opensource Cloudsqlproxy server or similar?

We've got one of our projects using a Google CloudSQL Postgres DB. We really like the cloudsqlproxy and how it keeps access to the DB locked behind our google accounts (which have 2FA). We've got another project using a DB on another managed…
ChrisJ
  • 295
  • 1
  • 10
0
votes
1 answer

Cloud SQL Server get sa password

I have created an SQL Server instance in Google Cloud SQL, I have the sqlserver user but it doesn't have sysadmin permission, so I want to know if it's possible to get or reset the password of the sa user.
netotz
  • 3
  • 2
0
votes
1 answer

Get the latest PostgreSQL version available in a region

Is there any gcloud cli command or api call that I can use to see the latest/newest available PostgreSQL versions in region? I found db-versions page, but I need to check which is the latest/newest available version programmatically.
Jovan Kostovski
  • 5
  • 1
0
votes
1 answer

ETL to bigquery using airflow without have permission cloud storage/ cloud sql

i have done ETL from MySql to bigQuery with python, but because i haven't permission to connect google cloud storage/ cloud sql, i must dump data and partition that by last date, this way easy but didn't worth it because take a much time, i want to…
user546730
  • 1
0
votes
1 answer

How to replicate Cloud SQL for PostgreSQL data to an external on-premise PostgreSQL DB

I've gotten a case that I need to replicate data from Cloud SQL for PostgreSQL to an external on-premise PostgreSQL DB. I've read the document and found that Cloud SQL for PostgreSQL does not support external replication yet. I've tried to search…
Satjapong Meeklai
  • 101
1 2 3
…
8 9