From: | amul sul <sulamul(at)gmail(dot)com> |
---|---|
To: | sonams1209(at)gmail(dot)com |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: connection error |
Date: | 2018-09-07 11:40:43 |
Message-ID: | CAAJ_b95d4nCvc0U+s24EhwejDqxa8U8YdB5yyb6Hy=PKhFDfKg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)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 postmaster is accepting TCP/IP connections.
>
>
> the port no is set correct :
>
> [postgres(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | amul sul | 2018-09-07 11:45:39 | Re: connection error |
Previous Message | Benjamin Scherrey | 2018-09-07 11:08:55 | Re: A Timeseries Case Study: InfluxDB VS PostgreSQL |