Re: Postgres keep alive configuration

Daniel Westermann (DWE) <daniel.westermann@dbi-services.com>

From: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>

To: Fabrice Chapuis <fabrice636861@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-07-23T11:30:54Z

Lists: pgsql-hackers

>From: Fabrice Chapuis <fabrice636861@gmail.com>
>Sent: Wednesday, July 23, 2025 13:20
>To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
>Subject: Postgres keep alive configuration
> 
>Hi,
>
>I try to configure these 3 parameters to activate keep alive on a sever Postgres in version 14.
>
>tcp_keepalives_idle = 3
>tcp_keepalives_interval = 2
>tcp_keepalives_count = 30

>After issuing alter system set ... command and a pg_reload_conf(); these parameters keep value 0.

Did you create a connection over the network when checking the values or are you connected over a socket? For socket connections these values will always be 0.

Regards
Daniel