postgresql - Connecting to Google Cloud SQL Postgres instance using psycopg2

Question

I am trying to connect to Google Cloud SQL Postgres Using psycopg2.

I have created an postgreSQL instance and using the default database postgres for now. I am able to connect from pgadmin tool as well as from the gcloud shell and the queries give expected result.

I have developed a flask application and deploying on standard app engine.

conn = psycopg2.connect(database="postgres", user = "postgres", password = "password", host = "/cloudsql/my-new-db")

And when I run it, the get psycopg2.OperationalError: could not connect to server: No such file or directory error.

I have a hunch that host value is not correct. I tried various options like /cloudsql/<prj-name>.<region>.<db-instance-name>

But, nothing seems to be working. What else should I be doing to remove this error?

Answer 1

Waitting for answers