MIME-Version: 1.0
References: <SJ2PR02MB97060CFEDBDE9FC11F1844358EBD2@SJ2PR02MB9706.namprd02.prod.outlook.com>
In-Reply-To: <SJ2PR02MB97060CFEDBDE9FC11F1844358EBD2@SJ2PR02MB9706.namprd02.prod.outlook.com>
From: Muhammad Imtiaz <imtiazpg712@gmail.com>
Date: Tue, 6 Aug 2024 13:31:04 +0500
Message-ID: <CACW1Ly2uckFX2=b_u+52zn_fd1D_rewtu3r79-XZOqyJbZWeQg@mail.gmail.com>
Subject: Re: Can't change tcp_keepalives_idle
To: "Abraham, Danny" <danny_abraham@bmc.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fc4d5c061eff9dc2"
Archived-At: <https://www.postgresql.org/message-id/CACW1Ly2uckFX2%3Db_u%2B52zn_fd1D_rewtu3r79-XZOqyJbZWeQg%40mail.gmail.com>
Precedence: bulk

--000000000000fc4d5c061eff9dc2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

This parameter is supported only on systems that support TCP_KEEPINTVL. And
please ensure that you are not accidentally connecting through a
Unix-domain socket.  If the result of this query is null then it is a Unix
socket based connection.

SELECT client_addr FROM pg_stat_activity WHERE pid =3D pg_backend_pid();


Regards,
Muhammad Imtiaz

On Sun, Aug 4, 2024 at 4:16=E2=80=AFPM Abraham, Danny <danny_abraham@bmc.co=
m> wrote:

> Hi,
>
> Change tcp_keepalives_idle in postgresql.conf from 0 to 300 , then pg_ctl
> reload but it stays with the old 0 value.
> Tried restart and it did not work. PG Log says it was changed.
> Reset_cal marked OK, but no real change ( ins how)
>
> -[ RECORD 1 ]---+-----------------------------------------------------
> name            | tcp_keepalives_idle
> setting         | 0
> unit            | s
> category        | Connections and Authentication / Connection Settings
> short_desc      | Time between issuing TCP keepalives.
> extra_desc      | A value of 0 uses the system default.
> context         | user
> vartype         | integer
> source          | session
> min_val         | 0
> max_val         | 2147483647
> enumvals        |
> boot_val        | 0
> reset_val       | 1800
> sourcefile      |
> sourceline      |
> pending_restart | f
>
> Thanks
>
> Danny
>
>
>

--000000000000fc4d5c061eff9dc2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><font color=3D"#000000">Hi,<br><br><span style=3D"font-fam=
ily:&quot;Open Sans&quot;,sans-serif">This parameter is supported only on s=
ystems that support=C2=A0</span><code style=3D"box-sizing:border-box;font-f=
amily:monospace,monospace;border-radius:0.25rem;margin:0.6rem 0px">TCP_KEEP=
INTVL</code><code style=3D"box-sizing:border-box;border-radius:0.25rem;marg=
in:0.6rem 0px"><font face=3D"Open Sans, sans-serif">. And please=C2=A0</fon=
t></code>ensure that you are not accidentally connecting through a Unix-dom=
ain socket.=C2=A0 If the result of this query is null then it is a Unix soc=
ket based connection.<br></font><pre><div class=3D"gmail-dark gmail-bg-gray=
-950 gmail-rounded-md gmail-border-[0.5px] gmail-border-token-border-medium=
"><div class=3D"gmail-overflow-y-auto gmail-p-4" dir=3D"ltr"><code class=3D=
"gmail-!whitespace-pre gmail-hljs gmail-language-sql"><font face=3D"arial, =
sans-serif"><span class=3D"gmail-hljs-keyword">SELECT</span> client_addr <s=
pan class=3D"gmail-hljs-keyword">FROM</span> pg_stat_activity <span class=
=3D"gmail-hljs-keyword">WHERE</span> pid <span class=3D"gmail-hljs-operator=
">=3D</span> pg_backend_pid();</font></code></div></div></pre><br>Regards,<=
br>Muhammad Imtiaz=C2=A0<br></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Sun, Aug 4, 2024 at 4:16=E2=80=AFPM Abraha=
m, Danny &lt;<a href=3D"mailto:danny_abraham@bmc.com">danny_abraham@bmc.com=
</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:=
0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=
Hi,<br>
<br>
Change tcp_keepalives_idle in postgresql.conf from 0 to 300 , then pg_ctl r=
eload but it stays with the old 0 value.<br>
Tried restart and it did not work. PG Log says it was changed.<br>
Reset_cal marked OK, but no real change ( ins how)<br>
<br>
-[ RECORD 1 ]---+-----------------------------------------------------<br>
name=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | tcp_keepalives_idle<br>
setting=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 0<br>
unit=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | s<br>
category=C2=A0 =C2=A0 =C2=A0 =C2=A0 | Connections and Authentication / Conn=
ection Settings<br>
short_desc=C2=A0 =C2=A0 =C2=A0 | Time between issuing TCP keepalives.<br>
extra_desc=C2=A0 =C2=A0 =C2=A0 | A value of 0 uses the system default.<br>
context=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| user<br>
vartype=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| integer<br>
source=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | session<br>
min_val=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 0<br>
max_val=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 2147483647<br>
enumvals=C2=A0 =C2=A0 =C2=A0 =C2=A0 |<br>
boot_val=C2=A0 =C2=A0 =C2=A0 =C2=A0 | 0<br>
reset_val=C2=A0 =C2=A0 =C2=A0 =C2=A0| 1800<br>
sourcefile=C2=A0 =C2=A0 =C2=A0 |<br>
sourceline=C2=A0 =C2=A0 =C2=A0 |<br>
pending_restart | f<br>
<br>
Thanks<br>
<br>
Danny<br>
<br>
<br>
</blockquote></div>

--000000000000fc4d5c061eff9dc2--