From: "Abraham, Danny" <danny_abraham@bmc.com>
To: pgsql-general <pgsql-general@lists.postgresql.org>
CC: "Abraham, Danny" <danny_abraham@bmc.com>
Subject: Can't change tcp_keepalives_idle
Thread-Topic: Can't change tcp_keepalives_idle
Thread-Index: AdrmXzllRYiYfkjPQMKKWJ1y2fGMPg==
Date: Sun, 4 Aug 2024 11:16:21 +0000
Message-ID:
 <SJ2PR02MB97060CFEDBDE9FC11F1844358EBD2@SJ2PR02MB9706.namprd02.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?2KR47BcA+8sGFfx7W5YD52ZqFK2RlywKcHDnDwpASGHq8Is4I4Uxr8hj1mAC?=
 =?us-ascii?Q?J2To6bKadrHSk7ExnUMmyW4V7udjB5Uc1jFau+dnD7FjYOesghShekkLqP/V?=
 =?us-ascii?Q?ub+jZrO586NLt9tNvBEy6KTB8b847gJgVJWWQMOY0oc5lIz+US+rqyXeFG9H?=
 =?us-ascii?Q?T1grH5cboyO6e4+3KszYSLaPR53km+iwApIRWLxjSw49bgZ+vRg8Xvt6dmLY?=
 =?us-ascii?Q?FTLTc7sU0iNE/G8NQtxozEiNzB1imIfga8+VjHlZzB/IcpXg2H95VFkm2Vc+?=
 =?us-ascii?Q?BQoRfbJXZvC8PbWZVknODrVebcmti1ZHFl2G0sOok28ftTnYVesgsImktF//?=
 =?us-ascii?Q?3sCQBp02i547VD81GRPSTNwsw9yfZDKnOoid+enp2IorxwNWxAz7vsCv/mi9?=
 =?us-ascii?Q?SFQ6lE5LJs1qPKIUTPH7aCVRjM2jq4AWj9q3UUc4VbvYHI/wgl4kJ7HRy/xG?=
 =?us-ascii?Q?Ops3tuhgkoye8oQMue9ECzzAiHlha8LDZBdoBrRe0FEVmyCA0JpPAzyplavm?=
 =?us-ascii?Q?iqy1tlXvNc6iARpQr730Nx9JWlRy/BE2oUe/owdoB5tPfgK09D9pzjNm9CxI?=
 =?us-ascii?Q?ukGxcTN7EBv4RSBOGxSaCmOu6+wcH0bmG8Aw3JYIcYMczKHcniZs5lcx1nXS?=
 =?us-ascii?Q?rt9tQAsvC2a8B2J8kK7HiRln1onqgb9YxgOmPVL7nHxZHpLbyUuPnR7ZHB2u?=
 =?us-ascii?Q?sCkB9Mew0M1IGsgmnvjkPc4XPmkoGvPmtggSXNP+iIeD9thDzN6iVBp1kqim?=
 =?us-ascii?Q?Mx5KF1nWRvAe8+6fZ61pVFyuuXy4MjTISnmcG94d2qwLlnyEJUPHuK2NdQO9?=
 =?us-ascii?Q?fuRECbGfQxbX0KvYttNXETp/3mH0rMbmW8bnYp7+LDOUwCL7eY4zOFP0rj1r?=
 =?us-ascii?Q?BYBDpy/doFuyVhUnlzh1aCrjH3tFyNiIjou/Jm+MRmJx2BR5aGmhmyxxBFlV?=
 =?us-ascii?Q?lCz6HkafD+sud09fYc7yMq+veg8djRpIkXxzKpqdT+1ueESCWwIL7uW1Pbbb?=
 =?us-ascii?Q?CfBh5TSACiUe33I09BKfOQOTeInucp96u5StTUvkFmfM7Hg6ERK4uQGXACXz?=
 =?us-ascii?Q?8CZac0ThGqF/PxLXwqQZqiRxOTSvkFknotrxbN2U5o84DAvSrElxnTIpT5JO?=
 =?us-ascii?Q?WkC4tvcC6YbbOQF5dce/UNEzOh5Cty1B4lcd3orvIiOdZtoyyT74OFNfuBmF?=
 =?us-ascii?Q?7ofghp4q45VvSN/PvslXchHzV9MEPN6e8ujHSll/O3ucQmkOTloEsgxXKQBE?=
 =?us-ascii?Q?wFIBrr9/Azc+D9KqWU/PqnUhGW65fqyWMaii8C2EV207UeP2qPC5X3Pm/2ma?=
 =?us-ascii?Q?hkr711p27KeMVbn1xe4E192XFgbRi0dmtJCVgHYzo0hJJ/hzFBmi8f3hjKq2?=
 =?us-ascii?Q?cWJ/0I9jct0HXVlVSjRkCJZGycBfdjzA8Rkrrnms+8XdSx2vcehYK/XRnCEk?=
 =?us-ascii?Q?Y9kBxwcTykbIeouJJaPzLk5bGUxRwKCVTbRB2jBKX7JvcculooD6ikNurM/J?=
 =?us-ascii?Q?hKMgSzD9hkpA2zLZJg1p/a2zosnU8uQFkDd0tJuAOErA9g+4w76KEBIoMk/E?=
 =?us-ascii?Q?Y8OH72AapUvrI1kFTu0=3D?=
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: bmc.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: SJ2PR02MB9706.namprd02.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 2e4f7848-9d50-4db7-45b6-08dcb476de7c
X-MS-Exchange-CrossTenant-originalarrivaltime: 04 Aug 2024 11:16:21.1581
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 92b796c5-5839-40a6-8dd9-c1fad320c69b
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: aTO4qOvkuMW2feszulwYtFVmKUUspHgkLV5kOXyMdMDe3iT/XGJCKetfD7qYDl5pS2zoBziQYL7UnOeqSZpuAA==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY5PR02MB6612
X-Proofpoint-ORIG-GUID: 6RV6NjeG2Dvnkg4yMJVS6PTAwkWQYyPS
X-Proofpoint-GUID: 6RV6NjeG2Dvnkg4yMJVS6PTAwkWQYyPS
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.293,Aquarius:18.0.1039,Hydra:6.0.680,FMLib:17.12.28.16
 definitions=2024-08-04_08,2024-08-02_01,2024-05-17_01
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 suspectscore=0 clxscore=1011
 bulkscore=0 priorityscore=1501 spamscore=0 mlxscore=0 phishscore=0
 adultscore=0 malwarescore=0 lowpriorityscore=0 mlxlogscore=931
 impostorscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.19.0-2407110000 definitions=main-2408040082
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/SJ2PR02MB97060CFEDBDE9FC11F1844358EBD2%40SJ2PR02MB9706.namprd02.prod.outlook.com>
Precedence: bulk

Hi,

Change tcp_keepalives_idle in postgresql.conf from 0 to 300 , then pg_ctl r=
eload 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