3,872 questions
0
votes
0
answers
46
views
cloudsql gcp PGAUDIT
I activated pgaudit on my Cloud SQL instance by adding the two flags enable and pgaudit.log, and I immediately saw audit logs in Cloud Logging without having to create the extension. When I connect to ...
0
votes
0
answers
36
views
How to create a vecs client using a Google Cloud connector based SQLAlchemy engine
I am trying to use vecs this library here and GitHub page but I have a big issue. When trying to create a vecs client it needs only the connection string Client(connection_string="...
- 5,059
0
votes
0
answers
104
views
Google Cloud Run service fails to connect to Cloud SQL despite all correct configurations and successful network tests
I'm facing a persistent deployment issue with a standard n8n application on Cloud Run and would appreciate any insights. My service consistently fails to deploy, with the container exiting due to a ...
- 1
0
votes
1
answer
70
views
Cloud Run Spring Boot App fails to connect to Cloud SQL (PostgreSQL) via Proxy: Connection refused [closed]
I'm deploying a Spring Boot application ( forestplus-back ) to Google Cloud Run ( europe-southwest1 ) and trying to connect it to a Cloud SQL PostgreSQL instance ( forsest-plus-db , also in europe-...
- 510
0
votes
2
answers
300
views
PostgreSQL 17.5: "canceling statement due to conflict with recovery or timeout" when creating logical replication slot on replica
I'm trying to create a logical replication slot on a GCP managed PostgreSQL 17 read replica but getting intermittent failures with two different errors. The replica was recently upgraded from ...
- 193
0
votes
1
answer
131
views
Cloud Run Fails to Connect to Cloud SQL (Server Not Found) After Exhaustive Troubleshooting
The Problem
I'm attempting to connect a .NET application running on Google Cloud Run to a Cloud SQL for SQL Server instance. I'm using the standard and recommended method with the Cloud SQL Auth Proxy ...
- 700
0
votes
2
answers
96
views
gunicorn.errors.HaltServer: <HaltServer 'App failed to load.' 4> in Google Cloud Run Function
I have deployed a Cloud Run Function and am frequently seeing this error:
2025-08-26 13:08:18.052 PDT DEBUG: False
2025-08-26 13:08:18.052 PDT Type of DEBUG: <class 'bool'>
2025-08-26 13:08:18....
- 75
1
vote
2
answers
226
views
How to find the table name and when it is last used in PostgreSQL?
I am using PostgreSQL (on GCP Cloud SQL) and I want to find out when each table in the database was last used (read or write).
So far, I have checked:
pg_stat_user_tables → this shows row counts, ...
- 31
0
votes
1
answer
83
views
What is the closest a role can be to a superuser in Google Cloud PostgreSQL? [closed]
I'm re-organizing the user structure in my Google Cloud PostgreSQL instance. Originally, we had a single user with broad access to everything. I'm now aiming for a more granular approach, where each ...
0
votes
1
answer
164
views
How can I track Cloud SQL backup costs per instance in GCP if resource.id is missing in the billing export?
I'm trying to analyze and optimize the cost of Cloud SQL backups in Google Cloud. In the GCP billing export, I see multiple line items with the SKU:
"Cloud SQL: Backups in [region]" (e.g., ...
- 1,081
2
votes
1
answer
214
views
cloud_sql_proxy giving auth: "invalid_grant" "Bad Request" though user has all permissions - how to debug?
A coworker has a problem with cloud_sql_proxy in GCP. We have a very simple setup, connections are done with the Google account, not service accounts, no IP restrictions or any other specialities.
For ...
- 1,755
0
votes
1
answer
303
views
Issues with Datastream (maybe related to pSQL 17.5)
Okay, so I had this all working. PSQL -> Datastream -> BigQuery. It's all in Terraform, so presumably repeatable.
I deleted the database, and restored from a backup, and now Datastream refuses ...
- 654
1
vote
2
answers
132
views
How do I create Cloud SQL connection in apphosting.yaml?
The documentation for configuring cloud run with cloud SQL (https://cloud.google.com/sql/docs/mysql/connect-run#configure) shows how to add the connection for a new rollout using the UI, but when you ...
- 437
1
vote
0
answers
94
views
Postgres (Cloudsql) shows lock wait on write transactions during an index creation (on unrelated table)
I am using Postgresql on CloudSQL (GCP), in version 15.
(Running on 4vCPU, 16Gb RAM, with SSD disk)
We are observing an unexpected issue during index creation.
While creating an index on a large-ish ...
- 656
1
vote
1
answer
509
views
Can't connect to PostgreSQL, from Google Cloud Run to Google Cloud SQL
Sup?
I want to connect to my PostgreSQL database on Cloud SQL from Cloud Run, and whatever I do, I get errors. The most annoying one is the "connection refused" error. I have tried anything ...
- 470