What is the hostname for a Google Cloud PostgreSQL instance?

Question

I'm trying to connect to a PostgreSQL database on Google Cloud using SQLAlchemy. Making a connection to the database requires specifying a database URL of the form: dialect+driver://username:password@host:port/database

I know what the dialect + driver is (postgresql), I know my username and password, and I know the database name. But I don't know how to find the host and port on the Google Cloud console. I've tried using the instance connection name, but that doesn't seem to work. Anyone know where I can find this info on Google Cloud?

Answer 1

• Hostname: Please use instance's IP address. There is "IPv4 address" field on the instance overview page in the Cloud Console, e.g. https://console.cloud.google.com/sql/instances/[Instance Name]/overview
• Port: we use default PostgreSQL port, 5432. I think it is possible to just omit it from the connection string.

Please also see "Connecting psql Client Using IP Addresses" page in our docs.

Answer 2

Hostname is the Public IP address.