when I connect postgres on the server to postico on my local I get this error
could not connect to server: Operation timed out Is the server running on host "http://126.96.36.199/" (188.8.131.52) and accepting TCP/IP connections on port 5432?
I could not find anywhere postgresql.conf and pg_hba.conf files, so i created the files, as you see in the below image
I found this explanation but still does not solve my issue
Ubuntu does not use the standard pg_ctl for postgreSQL. Instead, it uses pg_ctlcluster. That in turn controls the different PostgreSQL clusters. When you do an install of a new cluster, pg_ctlcluster is smart enough to put postgresql.conf & pg_hba.conf into separate dirs. So to be specific, /usr/lib/tmpfiles.d/postgresql.conf is just a tmp file that you can ingnore, /etc/postgresql/9.4/main/postgresql.conf is the original version for the 9.4 cluster and /var/lib/postgresql/9.4/main/postgresql.auto.conf is the actual, live version of the 9.4 cluster that you need to change to affect the 9.4 cluster. Likewise for the pg_hba.conf. reference https://www.postgresql.org/message- id/CANu8FiygR5CdeqRTiE0YM+BQk6aK+qZyw2frH_FWV27J1exong@mail.gmail.com
here how i configured postgresql.conf
here how i configured pg_hba.conf
host all all 0.0.0.0/0 md5 host all all ::/0 md5
when i run
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN - tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN - tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 29761/postgres tcp6 0 0 :::22 :::* LISTEN -
Clearly 5432 is not open for all connections.
when i make an api call using postman seems to work.
I use mac currently firewall not on, i have my server on digitalocean use Ubuntu 16.04.6 (LTS) x64.
This is the path of postgres files
when i run find / -name postgresql.conf i get this
but i cant find the path as logged in postgres user