pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Error LOG: could not receive data from client: Connection reset by peer
2+ messages / 2 participants
[nested] [flat]
* Re: Error LOG: could not receive data from client: Connection reset by peer
@ 2023-06-22 09:56 prathap vathuluru <prathap.vathuluru@outlook.com>
2023-06-22 13:51 ` Re: Error LOG: could not receive data from client: Connection reset by peer Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 2+ messages in thread
From: prathap vathuluru @ 2023-06-22 09:56 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hello All ,
I am seeing the below error message in My PostgreSQL Error log and My client is unable to connect to Database .
DB Level Log :
2023-06-22 09:30:10 UTC 192.168.0.60(22237) [29452-1] XXXXXX@XXXXXX LOG: could not receive data from client: Connection reset
by peer.
Application level Error :
Wed Jun 21 14:53:18 CEST 2023
SQL Error [08006]: An I/O error occurred while sending to the backend.
Could you please , Suggest relevant resolution for the Above issue ., We have 5 databases with enough resources in the same cluster .
Thanks In Advance ..!!
Regards,
Prathap V.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Error LOG: could not receive data from client: Connection reset by peer
2023-06-22 09:56 Re: Error LOG: could not receive data from client: Connection reset by peer prathap vathuluru <prathap.vathuluru@outlook.com>
@ 2023-06-22 13:51 ` Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2023-06-22 13:51 UTC (permalink / raw)
To: prathap vathuluru <prathap.vathuluru@outlook.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Thu, 2023-06-22 at 09:56 +0000, prathap vathuluru wrote:
> I am seeing the below error message in My PostgreSQL Error log and My client is unable to connect to Database .
>
> DB Level Log :
>
> 2023-06-22 09:30:10 UTC 192.168.0.60(22237) [29452-1] XXXXXX@XXXXXX LOG: could not receive data from client: Connection reset
> by peer.
>
> Application level Error :
>
> Wed Jun 21 14:53:18 CEST 2023
> SQL Error [08006]: An I/O error occurred while sending to the backend.
>
> Could you please , Suggest relevant resolution for the Above issue ., 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-postgresql-experience/
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-06-22 13:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-06-22 09:56 Re: Error LOG: could not receive data from client: Connection reset by peer prathap vathuluru <prathap.vathuluru@outlook.com>
2023-06-22 13:51 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox