locate pg_hba.conf   sudo vi /etc/postgresql/9.6/main/pg_hba.conf if need to add remote host go to remote server and try and psql to gcp box. i.e ssh to remote host and run psql -h **.***.***.** -U user database this will fail with the below error “error: could not connect to server: FATAL: no pg_hba.conf entry for host … More pg_hba.conf