proxy(?) server for connecting to cloud sql instance (GCP)

Question

I have a postgresql database on the google cloud platform (cloud SQL). I'm currently managing this database through pgadmin, installed on my laptop. I've added the IP address of my laptop to the whitelist on the cloud sql settings page. This all works.

The problem is: when I go somewhere else and I connect to a different network, the IP address changes and I cannot connect to the postgresql database (through pgadmin) from my laptop.

Is there someone who knows a (secure) solution, involving a proxy server (or something else), to connect from my laptop (and only my laptop) to my postgresql database, even if I'm not on a whitelisted network (IP address)? Maybe I can set up a VM instance and install a proxy server and use this? But I have no clue where to start (or search for).

cloud.google.com/sql/docs/mysql/sql-proxy

John Hanley
– John Hanley

2020-09-19 17:42:32 +00:00
Commented Sep 19, 2020 at 17:42 — John Hanley
– John Hanley, Commented Sep 19, 2020 at 17:42

Donnald Cucharo · Accepted Answer · 2020-09-30 19:18:23Z

1

You have many options for connecting to a Cloud SQL instance from an external applications such a Public IP address with SSL, Public IP address without SSL, Cloud SQL proxy, etc. You can see all of them here.

Between all connection options there exists Cloud SQL Proxy, it basically provides secure access to your instances without the need for Authorized networks or configuring SSL on your part.

You only need to follow the steps listed here and you will be able to connect your Cloud SQL instance using the proxy.

Enable Cloud SQL Admin API on your console.
Install the proxy client on your local machine (Linux):
- wget https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64 -O cloud_sql_proxy
- chmod +x cloud_sql_proxy
Determine how you will authenticate the proxy. You can use use a service account or let Cloud SDK take care of the authentication.
However, if required by your authentication method, create a service account.
Determine how you will specify your instances for the proxy. Your options for instance specification depend on your operating system and environment
Start the proxy using either TCP sockets or Unix sockets.

Take note that as of this writing, Cloud SQL Proxy does not support Unix sockets on Windows.

Update your application to connect to Cloud SQL using the proxy.

edited Sep 30, 2020 at 19:18

Donnald Cucharo

4,1721 gold badge13 silver badges21 bronze badges

answered Sep 21, 2020 at 17:39

Samuel Romero

1,2839 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

vhio Over a year ago

Could you elaborate on Step 7? I have been using Cloud SQL proxy for a Flask application and now I'm struggling to set it up for a Shiny app.

Collectives™ on Stack Overflow

proxy(?) server for connecting to cloud sql instance (GCP)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related