| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | prathap vathuluru <prathap(dot)vathuluru(at)outlook(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Error LOG: could not receive data from client: Connection reset by peer |
| Date: | 2023-06-22 13:51:22 |
| Message-ID: | ff9f047cdc1595e8d7604f5c3a446e98aeb48930.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wells Oliver | 2023-06-22 16:02:27 | work_mem + refresh mat view concurrently performance |
| Previous Message | prathap vathuluru | 2023-06-22 09:56:08 | Re: Error LOG: could not receive data from client: Connection reset by peer |