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

Posted July 11, 2020 1.3k views

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

edited by MattIPv4

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.

Submit an Answer
4 answers

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?

  • systemctl restart postgresql


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