Home > mailing lists

PostgreSql 9.4 Database connection failure - Mailing list pgsql-performance

From	Lionel Napoleon
Subject	PostgreSql 9.4 Database connection failure
Date	September 9, 2021 10:45:47
Msg-id	MA1PR01MB266894CCD61F36DF2B1E7D19DAD59@MA1PR01MB2668.INDPRD01.PROD.OUTLOOK.COM Whole thread Raw
Responses	Re: PostgreSql 9.4 Database connection failure
List	pgsql-performance

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

From: "ldh@laurent-hasson.com"
Date: 08 September 2021, 20:57:39
Subject: RE: Better performance no-throw conversion?

From: Ranier Vilela
Date: 09 September 2021, 14:55:42
Subject: Re: PostgreSql 9.4 Database connection failure