Message-ID: <ff9f047cdc1595e8d7604f5c3a446e98aeb48930.camel@cybertec.at>
Subject: Re:  Error LOG:  could not receive data from client: Connection
 reset by peer
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: prathap vathuluru <prathap.vathuluru@outlook.com>,
	"pgsql-admin@lists.postgresql.org"
	 <pgsql-admin@lists.postgresql.org>
Date: Thu, 22 Jun 2023 15:51:22 +0200
In-Reply-To: 
 <MAXPR01MB3328F773227E6C76B06CF21BFC22A@MAXPR01MB3328.INDPRD01.PROD.OUTLOOK.COM>
References: 
	<MAXPR01MB3328F773227E6C76B06CF21BFC22A@MAXPR01MB3328.INDPRD01.PROD.OUTLOOK.COM>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/ff9f047cdc1595e8d7604f5c3a446e98aeb48930.camel%40cybertec.at>
Precedence: bulk

On Thu, 2023-06-22 at 09:56 +0000, prathap vathuluru wrote:
> I am seeing the below error=C2=A0message in My PostgreSQL Error log and M=
y client is unable to connect to Database .
>=20
> DB Level Log :
>=20
> 2023-06-22 09:30:10 UTC 192.168.0.60(22237) [29452-1] XXXXXX@XXXXXX LOG: =
=C2=A0could not receive data from client: Connection reset
> =C2=A0by peer.
>=20
> Application level Error :
>=20
> Wed Jun 21 14:53:18 CEST 2023
> SQL Error [08006]: An I/O error occurred while sending to the backend.
>=20
> Could=C2=A0you=C2=A0please , Suggest relevant resolution for the Above is=
sue ., We have 5 databases with enough resources in the same cluster .

Usually, it is a network problem.

Try to adjust the TCP keepalive settings:

https://www.cybertec-postgresql.com/en/tcp-keepalive-for-a-better-postgresq=
l-experience/

Yours,
Laurenz Albe