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@gmail.com> 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
postmasteris 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