Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSql 9.4 Database connection failure

PostgreSql 9.4 Database connection failure

From
Lionel Napoleon
Date:
Hi,
      I have an issue with my PostgreSql 9.4 version database. Almost every week I get the following error

Error: #2147500037
Could not connect to the server;
Could not connect to remote socket immedaitely
Source: Microsoft OLE DB Provider for ODBC Drivers
SQL State: 08001

My application and database are on the same system. The communicating port being 5432.
initially I thought it was the permissible connection limit issue. So I raised the max_connections
parameter to 300.But still the problem exists.Would appreciate your speedy response to my
problem
Thanks & Regards
Lionel

Re: PostgreSql 9.4 Database connection failure

From
Ranier Vilela
Date:
Em qui., 9 de set. de 2021 às 04:46, Lionel Napoleon <lionelnapoleon@hotmail.com> escreveu:
Hi,
      I have an issue with my PostgreSql 9.4 version database. Almost every week I get the following error

Error: #2147500037
Could not connect to the server;
Could not connect to remote socket immedaitely
Source: Microsoft OLE DB Provider for ODBC Drivers
SQL State: 08001

My application and database are on the same system. The communicating port being 5432.
initially I thought it was the permissible connection limit issue. So I raised the max_connections
parameter to 300.But still the problem exists.

I think that question will be better answered at:

Re: PostgreSql 9.4 Database connection failure

From
Ranier Vilela
Date:

Em sex., 10 de set. de 2021 às 06:26, Lionel Napoleon <lionelnapoleon@hotmail.com> escreveu:
Hi ,
Hi, please when you post, choose to post to all.

     I was able to rectify most of the problems since they were from my application side bugs.
Good to know.

However  the following entry keeps coming in the postgresql log file:

2021-09-10 12:06:33 IST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.
Some connection (socket) from server, can't receive data from client.
Client stuck?


The application seems to be working despite of this log.My question is ..do I need to be worried of the above message
I think yes, your client still has some bug, but you can solve this
during development.

regards,
Ranier Vilela