can't connect postgres on the server to postico on my local

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 "" ( 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 below

base	pg_clog       pg_dynshmem  pg_logical	 pg_notify    pg_serial     pg_stat	 pg_subtrans  pg_twophase  pg_xlog		 postgresql.conf
global	pg_commit_ts  pg_hba.conf  pg_multixact  pg_replslot  pg_snapshots  pg_stat_tmp  pg_tblspc    PG_VERSION  postmaster.opts

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/ 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.

here how i configured postgresql.conf


here how i configured pg_hba.conf

     host    all             all                           md5
     host    all             all              ::/0                            md5

when i run

    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program 
    tcp        0      0    *               LISTEN      -
    tcp        0      0    *               LISTEN      -
    tcp        0      0*               LISTEN      
    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

Submit an answer

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!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

fixed the issue in postgres 9.5 postgresql.conf and pg_hba.conf files are located in


not in


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


Hi there @yasinahmed23,

Indeed it looks like PostgreSQL is binding on and not which would explain why you are not able to connect.

Have you restarted PostgreSQL after making the changes to the pg_hba.conf file?

  1. systemctl restart postgresql

Regards, Bobby

This comment has been deleted