CODEWITHSUNDEEP
postgresqlgoogle-cloud-platformgoogle-cloud-sql
timmyusa
timmyusa

Reputation: 29

Local Postgres database to Google Cloud PostgreSQL Github

I would like to build a Google Cloud PostgreSQL database using the instructions here

I was able to successfully create the Postgres databases with appropriate tables and views locally.

What do I need to do in order to get the data on Google Cloud PostgreSQL? My goal is to have remote access to this data.

Upvotes: 0

Views: 387

Answers (2)

Samuel Romero
Samuel Romero

Reputation: 1263

You have 2 options, The first one is use the Cloud SQL proxy as is described here. As the shared links say, the Cloud SQL Proxy provides secure access to your instances without the need for Authorized networks or for configuring SSL.

On the other hand, the second option is only to configure access to your instance under Authorized networks using or not SSL. The complete steps are listed here

Upvotes: 0

Lin Du
Lin Du

Reputation: 102527

You could connect to Cloud SQL from a local test environment using cloud sql proxy. See quickstart-proxy-test.

The workflow is:

Your Application(Running Locally) => cloud sql proxy (Running locally) => GCP remote Cloud SQL service

Upvotes: 0

Related Questions