utamori/go_pg_run.md

Last active September 24, 2020 06:26

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/utamori/4eeb35fa765379caababfda4bf14578e.js"></script>
Save utamori/4eeb35fa765379caababfda4bf14578e to your computer and use it in GitHub Desktop.

Download ZIP

Raw

go_pg_run.md

GoアプリからCloudSQLのPostgresに接続

参考：golang-samples/cloudsql/postgres/database-sql at master · GoogleCloudPlatform/golang-samples

事前準備

Cloud SQL Clientロールを持つSAとJSONキー作成

CloudRunへのデプロイ

gcloud run deploy run-sql --image gcr.io/[YOUR_PROJECT_ID]/run-sql \
  --add-cloudsql-instances '<MY-PROJECT>:<INSTANCE-REGION>:<INSTANCE-NAME>' \
  --set-env-vars INSTANCE_CONNECTION_NAME='<MY-PROJECT>:<INSTANCE-REGION>:<INSTANCE-NAME>' \
  --set-env-vars DB_USER='<DB_USER_NAME>' \
  --set-env-vars DB_PASS='<DB_PASSWORD>' \
  --set-env-vars DB_NAME='<DB_NAME>'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment