I can’t connect to instance of cloud sql via pgAdmin. It says connection timed out. I know this could be due to the port 5432 not opened on the firewall, but in the Cloud SQL instance there’s no firewall tab to open ports. Is there a way to open it?
Question posted in PostgreSQL
The official documentation can be found here.
2
Answers
Auth proxy might be a good option. https://cloud.google.com/sql/docs/postgres/connect-auth-proxy
It establishes the connection to the instance and opens up the local port through which applications can operate on the database.
The doc offers a few options to connect, but as already pointed out, the most locked-down are preferable. Out of those, if things get desperate and you already have:
gcloud compute ssh --tunnel-through-iapwith port forwarding on your ssh client or--ssh-flagto bounce off it and access the dbdblinkandpostgres_fdwsupported extensions you can use to cross-link