gcp cloud sql creating postgres database

We can easily create a postgres SQL using gcp. Go to cloud sql, then select postgres. 

 Then, provide a name for your instance. Provide a password and specify a region.

For my dev purposes, i would just use sandbox edition as oppose to production. 

Ensure you select 1vCPU for your  machine configuration and storage to use HDD. 

Once you have created it, you can connect to your database using SQL Cloud studio in your browser. So probably don't need to install another PG client.

Ensure you have whitelisted ips to connect to your database. You can goto Connection -> Add Network.