Do you have following entry as well? # IPv6 local connections: host all all ::1/128 trust I hope "listen_addresses " in postgresql.conf is on default setting. Regards, Amul Sul On Fri, Sep 7, 2018 at 4:08 PM Sonam Sharma <sonams1209@xxxxxxxxx> wrote: > > getting below error from application side : > ======== > > Last acquisition attempt exception: > > org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. > > > the port no is set correct : > > [postgres@lxsqlptgsdev004 data]$ psql -h localhost -p 5432 > > psql (9.5.14) > > Type "help" for help. > > > > postgres=# > > In pg_hba.conf also: > > > # IPv4 local connections: > > host all all 127.0.0.1/32 trust > > host all all 127.0.0.1/23 trust > > host all all 172.29.161.53/23 trust > > host all all 172.29.161.52/23 trust > > > Can someone please help what can be done to resolve this. > > > Thanks, > > Sonam
