How to Create PostgreSQL on google cloud platform.

PostgreSQL is one of the worlds fastest growing open source databases that is commonly deployed on popular cloud provider, Google Cloud Platform (GCP), to host organizations application data in the cloud.

 

  • Login to google cloud platform portal.
  • Click on SQL.

 

Fig 1

 

  • Click on Create Instance.

 

Fig 2

 

  • Select PostgreSQL.
  • Then click on choose PostgreSQL.

 

Fig. 3

 

  • Provide the Instance ID & Password.
  • Select Database version for instance: PostgreSQL 13 (default), PostgreSQL 12, PostgreSQL 11, PostgreSQL 10, or PostgreSQL 9.6.
  • Select Region & Zone.

 

Fig. 4

 

  • Click on Show Configuration Options.

 

Fig. 5

 

  • Click on Machine type.

 

Fig. 6

 

  • Select Machine type :Shared core, Lightweight, Standard (Most common), or High memory.

 

Fig. 7

 

  • Select Storage type & Capacity.

 

Fig. 8

 

  • Select Public or Private network for instance.
  • If needs to Add network click on Add network.

 

Fig.9

 

  • Provide New Network name & Network IP.
  • Click on Done.

 

Fig.10

 

  • Set the Backup.

 

Fig.11

 

  • At Maintenance, Select Preferred window & order of updates.

 

Fig.12

 

 

  • Click on Add Flag.

 

Fig.13

 

  • Provide the New database flag name.
  • Click on done.

 

Fig.14

 

  • Enable the Insights for monitoring the issues.

 

Fig.15

 

  • Click on Add Label.

 

Fig.15

 

  • Provide Key name & value for PostgreSQL database.
  • Click on done.
  • Then,Click on Create instance.

 

Fig.16

 

  • After sometime database is ready then go to PostgreSQL instance page.
  • PostgreSQL Database is there with the name we provide.

 

Fig.17

 

Leave a Reply