1. Home
  2. Docs
  3. Chainlink Node Setup
  4. GCP Cloud Server Setup
  5. Gcloud PostgreSQL Instance Setup

Gcloud PostgreSQL Instance Setup

Create a Cloud SQL instance

  1. Go to the Cloud SQL Instances page in the Google Cloud Platform Console. Go to the Cloud SQL Instances page
  2. Select your project and click Continue.
  3. Click Create Instance.
  4. Click PostgreSQL.
  5. Enter myinstance for Instance ID.
  6. Enter a password for the postgres user. Use the default values for the other fields.
  7. Click Create. You are returned to the instances list; your new instance is greyed out while it initializes and starts.

Configure access to your Cloud SQL instance

To configure access to your instance:

  1. Go to the Cloud SQL Instances page in the Google Cloud Platform Console. Go to the Cloud SQL Instances page
  2. Click the instance to open its Overview page, and record its IPv4 address.
  3. Log in to the client machine where your psql client is installed.
  4. Click What’s my IP to determine the IP address of the client machine.
  5. In the Instances page in the Google Cloud Platform Console, click the instance to open its Overview page.
  6. Select the Connections tab.
  7. Under Authorized networks, click Add network and enter the IP address of the client machine where your client is installed.
  8. Click Done, then click Save at the bottom of your page to save your changes.
  9. Connect to your instance, either with SSL or without SSL.

Dont forget to allow access in firewall!

PORT : 5432

Was this article helpful to you? Yes No

How can we help?

Leave a Reply

Your email address will not be published. Required fields are marked *