So I don’t have to google this every time.. Make sure you stop your local postgres instance.

Run this command to open a tunnel to the cloud sql instance in GCP.

cloud_sql_proxy -instances=<INSTANCE_NAME>=tcp:5432 -credential_file=<CRED_FILE> &

if the connection was successful you should now be able to tunnel into the remote cloud sql instance using…

psql "host=127.0.01 sslmode=disable dbname=<DB_NAME> user=<DB_USER> password=<DB_PASS>"