conf of postgres.cof

Поиск
Список
Период
Сортировка
От Sachin Kumar
Тема conf of postgres.cof
Дата
Msg-id CALg-PKB+c=0UiAKP2YXMw6HeYrXdh+jQSknY7-FW00sEkwXS+A@mail.gmail.com
обсуждение исходный текст
Ответы Re: conf of postgres.cof  (Patrick Headley <pheadley@linxco-inc.com>)
Список 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

В списке pgadmin-support по дате отправления:

Предыдущее
От: Aditya Toshniwal
Дата:
Сообщение: Re: pgAdmin 4 installation
Следующее
От: Patrick Headley
Дата:
Сообщение: Re: conf of postgres.cof