public inbox for [email protected]help / color / mirror / Atom feed
Can't change tcp_keepalives_idle 3+ messages / 3 participants [nested] [flat]
* Can't change tcp_keepalives_idle @ 2024-08-04 11:16 Abraham, Danny <[email protected]> 0 siblings, 2 replies; 3+ messages in thread From: Abraham, Danny @ 2024-08-04 11:16 UTC (permalink / raw) To: pgsql-general <[email protected]>; +Cc: Abraham, Danny <[email protected]> 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can't change tcp_keepalives_idle @ 2024-08-04 15:13 Adrian Klaver <[email protected]> parent: Abraham, Danny <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Adrian Klaver @ 2024-08-04 15:13 UTC (permalink / raw) To: Abraham, Danny <[email protected]>; pgsql-general <[email protected]> On 8/4/24 04:16, Abraham, Danny 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 source | session Something is setting the value for the session. Have you used https://www.postgresql.org/docs/current/sql-alterrole.html or https://www.postgresql.org/docs/current/sql-alterdatabase.html to SET tcp_keepalives_idle? Doing: select * from pg_db_role_setting ; will help answer the above. > > Thanks > > Danny > > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can't change tcp_keepalives_idle @ 2024-08-04 15:43 Tom Lane <[email protected]> parent: Abraham, Danny <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Tom Lane @ 2024-08-04 15:43 UTC (permalink / raw) To: Abraham, Danny <[email protected]>; +Cc: pgsql-general <[email protected]> "Abraham, Danny" <[email protected]> writes: > 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. tcp_keepalives_idle isn't implemented on all platforms. But I'd expect to see a LOG message in the postmaster log about that, either something about "setsockopt failed" or "WSAIoctl failed" or "setting the keepalive idle time is not supported". Also, if you inquire the value on a non-TCP connection, you'll get zero because it's not relevant. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-08-04 15:43 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-08-04 11:16 Can't change tcp_keepalives_idle Abraham, Danny <[email protected]> 2024-08-04 15:13 ` Adrian Klaver <[email protected]> 2024-08-04 15:43 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox