Scale up as you grow — whether you're running one virtual machine or ten thousand.

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.

This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi there @yasinahmed23,
Indeed it looks like PostgreSQL is binding on 127.0.0.1:5432 and not 0.0.0.0:5432 which would explain why you are not able to connect.
Have you restarted PostgreSQL after making the changes to the pg_hba.conf file?
- systemctl restart postgresql
Regards, Bobby
fixed the issue in postgres 9.5 postgresql.conf and pg_hba.conf files are located in
/etc/postgresql/9.5/main/
not in
/var/lib/postgresql/9.5/main/
you have to login as server root user and run each one of the command and that will give where are the files
find / -name postgresql.conf
find / -name pg_hba.conf
in my instance when i ran the command i got this
/var/lib/postgresql/9.5/main/postgresql.conf
/etc/postgresql/9.5/main/postgresql.conf
/usr/lib/tmpfiles.d/postgresql.conf
This comment has been deleted