Re: Can't change tcp_keepalives_idle
| От | Muhammad Imtiaz |
|---|---|
| Тема | Re: Can't change tcp_keepalives_idle |
| Дата | |
| Msg-id | CACW1Ly2uckFX2=b_u+52zn_fd1D_rewtu3r79-XZOqyJbZWeQg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Can't change tcp_keepalives_idle ("Abraham, Danny" <danny_abraham@bmc.com>) |
| Список | pgsql-general |
Hi,
This parameter is supported only on systems that support
Regards,
Muhammad Imtiaz
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_abraham@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
В списке pgsql-general по дате отправления: