Trouble connecting to Cloud SQL Postgres from Temporal Helm on GKE

Community Support Server Deployment
1

Hi everyone,

I’m trying to deploy Temporal on GKE using the temporal-helm chart, but I’m running into database connection issues.

I’m using Google Cloud SQL (Postgres) with its private IP address (not using cloudsql-proxy). Following the Temporal Helm guide for Postgres, I successfully created the required schemas/tables for both the persistence and visibility databases.

However, when I deploy Temporal, I get the following error:

sql schema version compatibility check failed: unable to read DB schema version keyspace/database: temporal error: no usable database connection found.

When I exec into one of the Temporal pods, I can connect to the database manually using the same credentials, so network access and authentication seem fine.

Here’s the relevant part of my Helm values:

image
image734×850 62.5 KB

Question:
Has anyone successfully connected Temporal Helm on GKE directly to a Cloud SQL Postgres instance over private IP?
Am I missing something in the Helm values (e.g., the way existingSecret is referenced, or the postgresql.enabled flag when using an external database)?

Thanks!