Aug 27, 2017 · 1 min read
remotly connect to postgres hosted on google compute engin
first :
in postgres :
sudo vi /var/lib/pgsql/data/postgresql.confmake sure the listen_address=”*”
listen_addresses = '*'then
sudo vi /var/lib/pgsql/data/pg_hba.confadd the followiung line
host all all 0.0.0.0/0 md5in Google firewall roles , we need to open the postgres port
go to https://console.cloud.google.com/networking/firewalls
create firewall rule
create ingress and Egress rules to allow two direction connectios
