Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgpool-hackers-owner+archive@lists.postgresql.org>)
	id 1wDh2U-003FTe-2O
	for pgpool-hackers@arkaria.postgresql.org;
	Fri, 17 Apr 2026 11:07:11 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgpool-hackers-owner+archive@lists.postgresql.org>)
	id 1wDh2R-009aDK-2G
	for pgpool-hackers@arkaria.postgresql.org;
	Fri, 17 Apr 2026 11:07:07 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <ishii@postgresql.org>)
	id 1wDh2R-009aDC-1h
	for pgpool-hackers@lists.postgresql.org;
	Fri, 17 Apr 2026 11:07:07 +0000
Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <ishii@postgresql.org>)
	id 1wDh2O-00000001e1X-1YT6
	for pgpool-hackers@lists.postgresql.org;
	Fri, 17 Apr 2026 11:07:07 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type:
	Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender
	:Reply-To:Content-ID:Content-Description;
	bh=qO4PGXTPwsocgQS2TXz0qMMcNkLP2dT8Gzs/J0nfkCw=; b=zsaD1SDZdLuxS2/tnn5S7iB15P
	KI3mfX131UqnXdqGPuwWcCBXyGGhCZpdz9T6azuVxfoRK7nTSvmCUo4vU6OpQL9S/Dpuu6K5mYYOP
	PvDJ/Hx5dNBae7O0Q7GZETNtIYbg+5YupnN5v+SIF5qvt8Ooi/gpli2nqYF7wTLmuYe02BfYl4zo9
	ezsfqbdYu2WiEwgNJcYOGP9/mEnUYRyMNY1s9MJl6MgHYFc2LLuLbd9npdQl7HMQoapUioJR7TQKj
	Z0qJ6ndr1Tr5iQRbIW9FIE8MCGMANAHpCbEblMISo7ePUwfRff30DcPWYLGILIMRJrIuyluHite4w
	kYnOu/Ww==;
Received: from [2409:11:4120:300:550a:addb:33eb:3166] (helo=localhost)
	by meldrar.postgresql.org with esmtpsa  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <ishii@postgresql.org>)
	id 1wDh2L-0041MP-2o;
	Fri, 17 Apr 2026 11:07:04 +0000
Date: Fri, 17 Apr 2026 20:06:56 +0900 (JST)
Message-Id: <20260417.200656.850534290259556895.ishii@postgresql.org>
To: bob.ross.19821@gmail.com
Cc: pgpool-hackers@lists.postgresql.org
Subject: Re: Rotate SSL certificates on reload (SIGHUP) without restart
From: Tatsuo Ishii <ishii@postgresql.org>
In-Reply-To: 
 <CAHtZvrcgCbM8=xTdxhdm_qOnQ4=ttAJpB_amTdG8r4NzcukYAQ@mail.gmail.com>
References: 
 <CAHtZvreKzO3fwfWZfmSPKjc0qN4P5bsvGMLhCir6gSK8pOFnXQ@mail.gmail.com>
	<20260417.073733.1428537764192913774.ishii@postgresql.org>
	<CAHtZvrcgCbM8=xTdxhdm_qOnQ4=ttAJpB_amTdG8r4NzcukYAQ@mail.gmail.com>
X-Mailer: Mew version 6.8 on Emacs 29.3
Mime-Version: 1.0
Content-Type: Text/Plain; charset=utf-8
Content-Transfer-Encoding: base64
X-Host-Lookup-Failed: Reverse DNS lookup failed for
 2409:11:4120:300:550a:addb:33eb:3166 (failed)
List-Id: <pgpool-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgpool-hackers@lists.postgresql.org>
List-Owner: <mailto:pgpool-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgpool-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/20260417.200656.850534290259556895.ishii%40postgresql.org>
Precedence: bulk

SGkgQm9iLA0KDQo+IEhpIFRhdHN1bywNCj4gDQo+IEkndmUgZml4ZWQgdGhlIHRlc3QgZmFpbHVy
ZS4gVGhlIGlzc3VlIHdhcyB0aGF0IHRoZSBvcmlnaW5hbCB0ZXN0IHVzZWQgdGhlDQo+IHN0YXRp
YyBzZWxmLXNpZ25lZCBzZXJ2ZXIuY3J0IGFzIHRoZSBDQSBidW5kbGUuIFdoZW4gc3NsX2NhX2Nl
cnQgaXMgc2V0LA0KPiBwZ3Bvb2wgdmVyaWZpZXMgdGhlIGJhY2tlbmQgY2VydGlmaWNhdGUgYWdh
aW5zdCBpdCwgYW5kIHRoZSBzZWxmLXNpZ25lZA0KPiBjZXJ0IGZhaWxlZCB0aGF0IGNoZWNrLiBU
aGUgZml4IGdlbmVyYXRlcyBhIGRlZGljYXRlZCBzZXJ2ZXIgQ0EgaW4gdGhlIHRlc3QNCj4gYW5k
IGlzc3VlcyBhIGJhY2tlbmQgY2VydCBzaWduZWQgYnkgaXQsIHNvIHBncG9vbCBjYW4gYWx3YXlz
IHZlcmlmeSB0aGUNCj4gYmFja2VuZCB3aGlsZSBjYTEvY2EyIGFyZSBpbmRlcGVuZGVudGx5IHN3
YXBwZWQgdG8gdGVzdCBjbGllbnQtY2VydCB0cnVzdA0KPiByb3RhdGlvbi4NCg0KVGhhdCBtYWtl
cyBzZW5zZS4NCg0KPiBUaGUgdGVzdCBub3cgcGFzc2VzOg0KPiANCj4gDQo+IA0KPiANCj4gDQo+
ICpDQSBjZXJ0IHN3YXA6IENBMS1zaWduZWQgY2xpZW50IGNlcnQgYWNjZXB0ZWQgYmVmb3JlIHJl
bG9hZCDigJMgb2suQ0EgY2VydA0KPiBzd2FwOiBDQTEtc2lnbmVkIGNsaWVudCBjZXJ0IHJlamVj
dGVkIGFmdGVyIHJlbG9hZCB0byBDQTIg4oCTIG9rLnRlc3RpbmcNCj4gMDQyLnNzbF9yZWxvYWQu
Li5vay5vdXQgb2YgMSBvazoxIGZhaWxlZDowIHRpbWVvdXQ6MCoNCj4gDQo+IHBncG9vbC5sb2cg
c2hvd2luZyBjbGllbnQgY2VydCBhY2NlcHRlZCBiZWZvcmUgcmVsb2FkOg0KPiANCj4gDQo+IA0K
PiANCj4gKjIwMjYtMDQtMTcgMDk6MjM6MzEuNDQ5OiBjaGlsZCBwaWQgODEzNzg6IERFQlVHOiAg
Z290IHRoZSBTU0wNCj4gY2VydGlmaWNhdGUyMDI2LTA0LTE3IDA5OjIzOjMxLjQ0OTogY2hpbGQg
cGlkIDgxMzc4OiBERVRBSUw6ICBQcm90b2NvbA0KPiBNYWpvcjogMyBNaW5vcjogMCBkYXRhYmFz
ZTogdGVzdCB1c2VyOiBzc2x0ZXN0MjAyNi0wNC0xNyAwOToyMzozMS40NTA6DQo+IGNoaWxkIHBp
ZCA4MTM3ODogREVUQUlMOiAgY2xpZW50LT5zZXJ2ZXIgU1NMIHJlc3BvbnNlOiBTMjAyNi0wNC0x
Nw0KPiAwOToyMzozMS40NTU6IGNoaWxkIHBpZCA4MTM3ODogREVUQUlMOiAgYXV0aCBraW5kOjAq
DQo+IA0KPiBTU0wgY2VydGlmaWNhdGUgcmVsb2FkIGNvbXBsZXRlZDoNCj4gDQo+ICoyMDI2LTA0
LTE3IDA5OjIzOjMxLjQ3MTogbWFpbiBwaWQgODEzNDc6IExPRzogIHJlbG9hZCBTU0wgY2VydGlm
aWNhdGVzLioNCj4gDQo+IHBncG9vbC5sb2cgc2hvd2luZyBjbGllbnQgY2VydCByZWplY3RlZCBh
ZnRlciByZWxvYWQ6DQo+IA0KPiANCj4gDQo+ICoyMDI2LTA0LTE3IDA5OjIzOjMyLjQ4NTogcHNx
bCBwaWQgODEzODU6IERFVEFJTDogIFNTTFJlcXVlc3QgZnJvbQ0KPiBjbGllbnQyMDI2LTA0LTE3
IDA5OjIzOjMyLjQ5MzogcHNxbCBwaWQgODEzODU6IExPRzogIHBvb2xfc3NsOg0KPiAiU1NMX2Fj
Y2VwdCI6ICJjZXJ0aWZpY2F0ZSB2ZXJpZnkgZmFpbGVkIjIwMjYtMDQtMTcgMDk6MjM6MzIuNDkz
OiBwc3FsIHBpZA0KPiA4MTM4NTogRVJST1I6ICBmYWlsZWQgd2hpbGUgcmVhZGluZyBzdGFydHVw
IHBhY2tldCoNCj4gDQo+IE5vIGNoYW5nZXMgdG8gdGhlIGNvcmUgcGF0Y2guDQo+IFRoZSB1cGRh
dGVkIHY0IGlzIGF0dGFjaGVkLg0KDQpOb3cgdGhlIHRlc3Qgc3VjY2VlZGVkIGhlcmUuICBNYW55
IHRoYW5rcy4gSSB3aWxsIHB1c2ggdGhlIHBhdGNoDQp0b21vcnJvdy4NCg0KUmVnYXJkcywNCi0t
DQpUYXRzdW8gSXNoaWkNClNSQSBPU1MgSy5LLg0KRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3Mu
Y28uanAvaW5kZXhfZW4vDQpKYXBhbmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0K