Обсуждение: PostgreSql 9.4 Database connection failure
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
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 errorError: #2147500037Could not connect to the server;Could not connect to remote socket immedaitelySource: Microsoft OLE DB Provider for ODBC DriversSQL State: 08001My 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_connectionsparameter to 300.But still the problem exists.
I think that question will be better answered at:
However, it seems to me that this is a bug with Microsoft ODBC.
regards,
Ranier Vilela
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