Postgres Pro
Downloads
Home   >   mailing lists

connection error - Mailing list pgsql-general

From Sonam Sharma
Subject connection error
Date
Msg-id CAM-M3TmTJhyoMLoZLZGy42RL3U9=yPB9LMp4AN=iFYuCLSdAeA@mail.gmail.com
Whole thread Raw
Responses Re: connection error  (amul sul <sulamul@gmail.com>)
RE: connection error  ("Ahmed, Nawaz" <Nawaz@fast.au.fujitsu.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Fabio Pardi
Date:
Subject: Re: A Timeseries Case Study: InfluxDB VS PostgreSQL
Next
From: Thomas Kellerer
Date:
Subject: Re: A Timeseries Case Study: InfluxDB VS PostgreSQL