| From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: tcp keepalives not sent during long query |
| Date: | 2022-12-15 07:31:30 |
| Message-ID: | CAHnozTh=o-n0cgcgP7M8iyzTKPLJfhrPFr17XwE8RTyjymnEMA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Dec 14, 2022 at 6:38 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willy-Bas Loos | 2022-12-15 07:48:36 | Re: tcp keepalives not sent during long query |
| Previous Message | Tom Lane | 2022-12-15 06:10:55 | Re: Test if a database has any privilege granted to public |