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 = pg_backend_pid(); Regards, Muhammad Imtiaz On Sun, Aug 4, 2024 at 4:16 PM Abraham, Danny <danny_abra...@bmc.com> 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 > > >
