I have deployed a SQL instance on a shared VPC subnet to host a PostgreSQL database in GCP. Now I want to connect to this instance from a machine whose network is private and external to google cloud. I am using Cloud SQL Python connector to do that, but when I run the python script on the machine it gets stuck at “Requesting ephemeral certificate”. Is this the right approach to establish such a connection?

My PHP app is on a DigitalOcean droplet while my MySQL 8.0 database is on Google Cloud SQL.

I am running postgres 11 in Google Cloud Sql. It’s the standard Enterprise edition. The only 2 extensions I’ve added was citext and dblink.