Home > mailing lists

conf of postgres.cof - Mailing list pgadmin-support

From	Sachin Kumar
Subject	conf of postgres.cof
Date	June 12, 2021 06:31:23
Msg-id	CALg-PKB+c=0UiAKP2YXMw6HeYrXdh+jQSknY7-FW00sEkwXS+A@mail.gmail.com Whole thread Raw
Responses	Re: conf of postgres.cof
List	pgadmin-support

Hi Experts,

I am using Postgres 12 and 13 in two f my server and getting timeout issue in frontend. after enabling the slow query i found the error.

" LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. "

and during troubleshooting, i found that it can be resolved by Setting both statement_timeout and idle_in_transaction_session_timeout

But i don't know the correct way to use it.

One server has 8GB RAM and other one have 32 GB RAM.

Kindly help me configuring these settings.

Thanks in Advance

Sachin

Best Regards,
Sachin Kumar

From: Aditya Toshniwal
Date: 10 June 2021, 09:10:59
Subject: Re: pgAdmin 4 installation

From: Patrick Headley
Date: 12 June 2021, 19:44:38
Subject: Re: conf of postgres.cof