Skip to content

Instantly share code, notes, and snippets.

@dimaKudr

dimaKudr/psql-and-proxy

Created April 4, 2020 20:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dimaKudr/e4d876e0e32a3a84883a1cd0ce495c20 to your computer and use it in GitHub Desktop.
Save dimaKudr/e4d876e0e32a3a84883a1cd0ce495c20 to your computer and use it in GitHub Desktop.
Download ZIP
cloud sql proxy
Raw
psql-and-proxy
# install psql
brew install libpq
ln -s /usr/local/Cellar/libpq/12.2_1/bin/psql /usr/local/bin/psql
# Mac: install cloud sql proxy
curl -o cloud_sql_proxy https://dl.google.com/cloudsql/cloud_sql_proxy.darwin.amd64
chmod +x cloud_sql_proxy
# start proxy
# INSTANCE_NAME example - kuber-test-02:us-central1:dev-server
#
./cloud_sql_proxy -instances=<INSTANCE_NAME>=tcp:5432
# when proxy started, connect to DB
psql --host=localhost --port=5432 --username=postgres
# list databases ('\l' command inpostgres)
\l
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment