Re: tcp keepalives not sent during long query

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема Re: tcp keepalives not sent during long query
Дата
Msg-id CAHnozTh=o-n0cgcgP7M8iyzTKPLJfhrPFr17XwE8RTyjymnEMA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: tcp keepalives not sent during long query  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: tcp keepalives not sent during long query  (Willy-Bas Loos <willybas@gmail.com>)
Re: tcp keepalives not sent during long query  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: tcp keepalives not sent during long query  (Geoff Winkless <pgsqladmin@geoff.dj>)
Re: tcp keepalives not sent during long query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения


On Wed, Dec 14, 2022 at 6:38 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
It'd be worth doing

show tcp_keepalives_idle;

Wow, you're right! It's in the postgresql.conf but it isn't set when I reload the server
A restart also doesn't do it and even doing SET tcp_keepalives_idle=120; doesn't work.
It gives me a confirmation, but then when I SHOW the value, it gives me 0.

wbloos=# set tcp_keepalives_idle=120;
SET
wbloos=# show tcp_keepalives_idle;
 tcp_keepalives_idle
---------------------
 0
(1 row)

--
Willy-Bas Loos

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Test if a database has any privilege granted to public
Следующее
От: Willy-Bas Loos
Дата:
Сообщение: Re: tcp keepalives not sent during long query