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.94.2) (envelope-from ) id 1ucHIw-00B643-B8 for pgpool-hackers@arkaria.postgresql.org; Thu, 17 Jul 2025 05:37:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ucHIu-00GowX-BO for pgpool-hackers@arkaria.postgresql.org; Thu, 17 Jul 2025 05:37:12 +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.94.2) (envelope-from ) id 1ucHIu-00GowQ-3U for pgpool-hackers@lists.postgresql.org; Thu, 17 Jul 2025 05:37:12 +0000 Received: from mail-japaneastazon11020088.outbound.protection.outlook.com ([52.101.229.88] helo=TY3P286CU002.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ucHIs-008CGf-1N for pgpool-hackers@lists.postgresql.org; Thu, 17 Jul 2025 05:37:12 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=hULe2831EpEVV07eOmcSiDfiS1RKbkpLNhyc0m5eivPPhbbIwd3i6eaTYxh44IYI1GrJ9kYCPRLHk5+jiHwXhAiSNiUcTnDfjudjqaJoyTIZv2CoVai6oXjKzQSUwUxgMa+eMUq2dPrc+7QRhwNJHFabJfK9KZACrbVU9DTAByt09uG8Y0AT1cR/H4GhSQzDADeoffGG8AdjXdiKhAINN3Y9NETY5oUO+j2IFp5vqcl4SandUHnqSprXz6Iuc6lkL62MimHvgXzFw9vIx1k5pYJaCqOzkN4S0FJSJLTbd6YI7ikof/BC2m7FfXjGHRzuVm88yGVdfEYgAA0uE952qg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=lNjir6iz/HjKcUW5J7yyRaHWu6Db7GVOpd03Mtpw3dE=; b=NuHLY8EWyrO9IcWagDO38KCGWm2HtnvdStsuCr5kdOucILdoICtGdqVVGAolX3aDxPOydX6/vMEnwXzb9UaI8g1CZvNHfT/wUql20yWPFRmVyBCgp5FGLeC8fSmNJSs3Io5T5LBrVQLQoLNSakGdz9t8f6wbpxiVL7ZaKeIFJ05Al2Sj/MCUz/BSlYTFGJav2lzB7eF+EKlOYl45jiRqSOUjYrskiFho3N6VXB4pPpsAl9MHjClUSDOJPVxruhsZCEgX2g1QGqn0zDDRM1JyW6X+xNJGHidEHy3RBm1cWM5Esec30W25wqnJGhvQYLO0rUrFSmaZkcyJL0aWVacNVg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=sraoss.co.jp; dmarc=pass action=none header.from=sraoss.co.jp; dkim=pass header.d=sraoss.co.jp; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sraoss.co.jp; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=lNjir6iz/HjKcUW5J7yyRaHWu6Db7GVOpd03Mtpw3dE=; b=ENs9vv5hIsHKPiWgMZn2m7f6tBnCsvJwTQtX+5fW3s4eQdqQZCPJDCVXotze1pXTmHTAM6H4RynZoR2hwe6o6ZRKJX0sHyDwagxLygnu4pLKE6bK5aerf5pJ2JzsbVwAbORybxQsyArA+rJ+pzHuDtfkF4OW35joLSjeLrklcJFTZkAexDScJHcac3Zjtf0rAeT4BNdZAqdhnNBRKpckrXAQmj/pFf38i1UsHs2Mi7Xk7KTc0mIFYCVOTSsOAuh85VpggQr/1hRESnH1AHKfvCgU/9/QrbEP0kmHAIyVgZSsSD0mSp2iJRm4MsgLamnP5lOvMJLAZKGHaMD3cIAvAw== Received: from TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:249::12) by OS7P286MB5312.JPNP286.PROD.OUTLOOK.COM (2603:1096:604:382::6) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8943.16; Thu, 17 Jul 2025 05:37:03 +0000 Received: from TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM ([fe80::66aa:2227:bbba:ead2]) by TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM ([fe80::66aa:2227:bbba:ead2%4]) with mapi id 15.20.8901.021; Thu, 17 Jul 2025 05:37:03 +0000 From: Bo Peng To: "pgpool-hackers@lists.postgresql.org" Subject: Re: Proposal: make the online recovery database configurable Thread-Topic: Proposal: make the online recovery database configurable Thread-Index: AQHb5onDsO6HpuBqNkyoapQaTzQ9CbQ17FnB Date: Thu, 17 Jul 2025 05:37:02 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=sraoss.co.jp; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TYWP286MB2633:EE_|OS7P286MB5312:EE_ x-ms-office365-filtering-correlation-id: f142571f-cb44-4ed8-4857-08ddc4f3f570 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|376014|1800799024|38070700018|3613699012|7053199007; x-microsoft-antispam-message-info: =?iso-2022-jp?B?K1JybW16VE8xamRqUW9uMnR5bUkrQWJNMWVuaVpyZ1p0MEJET0pHWFJk?= =?iso-2022-jp?B?eGRqN09pUmhsdmhPdTBFZTZ5UGJranFVNmlaY3FWM2VpK2FWT05yUldK?= =?iso-2022-jp?B?bUtYM2ErRVZQZFJtQXdNYUFSbUgrVEd2L0pIN0hsM29NWmZGS04wa0po?= =?iso-2022-jp?B?UU05aTMvVzcwb1d0ZzMrK1BaTGZmZUsrbC9tak92eFhjVGNRaVk1OVlj?= =?iso-2022-jp?B?b3pBVFl5T290Nmo0UWZlajAvN05oazVraXlzWldvam15dTRCeDQ1U0Z6?= =?iso-2022-jp?B?K2VQc2RkWWlVR3VsTHhEU3NTbG5kZjJ5OGozQzR3clhVenB0aUF2dXhS?= =?iso-2022-jp?B?Q09ScG1Qb2VHbnhZVjRWK0ZTQTA1cE1Yd0R0RnJUWWpJWUliemJISVJV?= =?iso-2022-jp?B?dmtvV0VkVGZNaE1YSjM2eTdtOVhOSlFWUjd1ZlVIaHJTZGJqVHRGRHFh?= =?iso-2022-jp?B?OHdPUnZoLytWZGdMaU5ubVhZQ01QNERmVzNFVldWYU54MmJ2UUowSjZj?= =?iso-2022-jp?B?MXdsR2ovWlpMbnBWcFcyNFFNZDlyWnBoN2kwbWxZWG0rMWFzb0ZPOFlC?= =?iso-2022-jp?B?b0lHdmM4U3k3ZGtqZ0xCcTEycmlnclJMZ1FsVVRDcWJ2M2lwell3R3oz?= =?iso-2022-jp?B?Q0lJRitrTHhYdFBlc0EyWXFmRG9sSTBoTEhHNXJzcmJiZTlMQXJIc0tq?= =?iso-2022-jp?B?UzRvaGNYRGFOeVBqWWNlU1o1dktjUmJhTXVGZTMzZDRDRnhDbEZZRzV2?= =?iso-2022-jp?B?dVRwV3JPN0tTT2ZwQy9DeTVJc2hzL2JoZGVuM1ZHRTU4anJyZWhMekwx?= =?iso-2022-jp?B?RmlXR3pIVWFTWE9TMk5LS3dCeGc2dWkzY3UyUmkyNWorS1JOVFphbG5w?= =?iso-2022-jp?B?OWwrWWZ5MGQwcFBnR3k1NWhvT0lyTE05Z2NNY1N3UWxEdzE2TmhteHJR?= =?iso-2022-jp?B?NjlpZWh4Q1VpYms1R3d5QnFiVnpQTmNrZXNXdjlkUG1UOXJ4dWh1bERJ?= =?iso-2022-jp?B?YmU5UW0xVkdzSUt6SjdDL2Z6bXl2V29SbWljTkxPN29MbUZUcUtHWTNr?= =?iso-2022-jp?B?N0JDSFErMlFaanNlNFZOaXdGZ3ZYNXdKb09nTVBGQ1lGd0c3eEtLK1M3?= =?iso-2022-jp?B?WkEyZmdQYkdZa3lsa3MrUGxPYnlrdDRTclZDQVA5S0NpcTh2aUJpcmJ2?= =?iso-2022-jp?B?aWJ1SmlQeVh3UlV4V281SmQwTVp0R0dDUkMxODBzYVdGOGZtVGpOcHlX?= =?iso-2022-jp?B?NzV5S3d5VnU3d0g0Q01nQk5aeEZjRHZqUGZmck1kYW5FamNCZ3FhWnoz?= =?iso-2022-jp?B?T3ZabGllbjV2enJRWlRyZkg2c3lyRTB5WUp1YVV6bmRQajZpQnRubzg3?= =?iso-2022-jp?B?eVFvallUZEJleE9tbkFiZlNya1hIV2hkRFZ6Z2V0eUFvOEdIWUx6NFFW?= =?iso-2022-jp?B?MWZUa1FPendVTE1rMzdJTWZFNXp5aGxTR2h2c0trampxNk9qVHNmbEFp?= =?iso-2022-jp?B?TWZaMlFDdSt2cXByU0pGd1A4MEE3NXlsMjFqekNTWU9qeUo3Wks4VWFo?= =?iso-2022-jp?B?OGN5Wm1aaGdHaG5GUTVoOXJlTTFvSUdkQ2VOSjB4WW9vbzFNL0JGMVQ0?= =?iso-2022-jp?B?dFhjYlVaYzFuOGlKbE9oTWNOVDR4eHRHVTBzZk1UT1FPN0Z0WjdYY2tJ?= =?iso-2022-jp?B?Kzd3TDU2QlZkVWtKODRSYnVQS0dHZjgrcE5raDUwZm5WQzcxTVJXajVw?= =?iso-2022-jp?B?NWtkdE9hNDF3S1dqRmxmaHVaLy8rZ1lUQWhoR0c5RWhVVWwreTFqK1ds?= =?iso-2022-jp?B?TVJ0UHBzVXlDOEZTREtmVmNTY2NVam9GY0x2ZWRja0dJbE9PeVg2STlV?= =?iso-2022-jp?B?Q3VOS1ZYamdBYUVkZGZ0M042djNRdTRiSjBCQkU3Y1hjRmFYMVdVc3Y3?= =?iso-2022-jp?B?TTdRTXRadm5vNkxzV0E5TTZqRGZOZ3FvcWx1M2J0QU02UUF1dVI4alpX?= =?iso-2022-jp?B?L005V3pZdWptV2UzNU9WNGdkQ1FTcVNHL3dMZU5qSnVmT1ljQ2RnSGJF?= =?iso-2022-jp?B?MnBwRFdrc3lyc3ZveUZ2REZZRGxEbDFJOGoweTlZbWVxazY1UEtPcDlD?= =?iso-2022-jp?B?Ni8=?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(366016)(376014)(1800799024)(38070700018)(3613699012)(7053199007);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-2022-jp?B?R2dLU1dtdWtla2UrMm1KckVxVisyMVhJS2s2K1NNMmRsVDBEZXVPN05r?= =?iso-2022-jp?B?c0FnTFFOcFV6UC9JLzNkOVpDZmpEQ2FtelNNNmRtWjRrZW90bjgvV1Vz?= =?iso-2022-jp?B?Y2xtcFZXa1h2a2U3Y0pJaGlGVU4rV3U1RS9Jb3daNXgrR1Z6Q2NuN1JE?= =?iso-2022-jp?B?SHdTT05DZWJTWEgwNEVKbnFHUW0xOUEzckE5cHFTSFpacUM4c2kvZHBG?= =?iso-2022-jp?B?NlpEOGlMK1U5SWhMTlB2WDdqQ1RpTVVCbFdIeWxPeGFZa1pOTk9WSzZD?= =?iso-2022-jp?B?U2piNStmTUFkK08rUno5V2tRQWxQMWVETzJxWEtDMVZSMHk0bFBSOVhB?= =?iso-2022-jp?B?WmJhZ0JOODFKTTVzdTRxQnoveEpDUWJ4NlFuU2R6bUpkemZ0QnpUNk9E?= =?iso-2022-jp?B?bFlYWURsWm5IakNSdW95Nis5NVUvVzFWSklWeFAraFpBekhOWm83bW1w?= =?iso-2022-jp?B?bnNOZ29EMmJVcVA4RFh1bWlEbFpyaGZiWWZPcThNRlFqbkszWXB4a3pH?= =?iso-2022-jp?B?VWhVcGExSzRVNy9BVGx5SjBvOXhpQjBLNkwrc3VPM1hFKytjbHRNbjFu?= =?iso-2022-jp?B?Si8vNGJDVlJXN0VNZ05GRFJBZWt4ZENuempEOEM3K1p2dVhRUHJCcVJ6?= =?iso-2022-jp?B?RytCbXFkb1ByV0owbXpkcm9RcUR3M2U4MllaUk4xSHFjbVl4a3R2S29v?= =?iso-2022-jp?B?NVgvdm84TGt3MGZQQ0hpZG1uNFhCUlVuVWhxT3pGQU0yY1ZrTENOUUlu?= =?iso-2022-jp?B?TjBZRkltcVRjU3FxeDAvOUJHT3dQTzVEY2Q5RzhOTFBZNnp3UGV3empG?= =?iso-2022-jp?B?QndmTlJsMXlsajUyZlVqN01JN3N1NHVocC8vOG9naTJ5UjlySW5vZnBU?= =?iso-2022-jp?B?UXdFcGNCZi9yMDFjQ3BMNXNnQlNqb0x0WG5LVHN1Z2oyanZxb1hrVTh5?= =?iso-2022-jp?B?YzVjc3RCWEhqRGY4eDAxcVY2b29jejhXbko1TWRtcWZ1cnhyVko0dDdQ?= =?iso-2022-jp?B?K2xYNUljZW9QYzBETzlYMUJOMnlUKzBzb1RMcStlZnpzN3RyOCtJVWlh?= =?iso-2022-jp?B?aFNnd0x4bCtuS2MrRjROTDI3THU4TVZkVmUzd0VlTGdQenB2T2lUVVpQ?= =?iso-2022-jp?B?c20wcmxvak9pZ3RUMWhWWVpyS2phbyttYmV1dytOcXJmcGZuVG1GbUwr?= =?iso-2022-jp?B?Z0hmeTFUbFBZaWFDd200eW1pamtMRy9icFVIUmdDY3dNNDgwbGs0YXFn?= =?iso-2022-jp?B?ZWRwSGtaRkxLeW1CQmdISHpJemp0d3B4M2Jnd2xVZ0JTKzJPYVc1Q0N3?= =?iso-2022-jp?B?ZURPVmprREl6VWk2cE14eVlGZnEybFBvUGQySGtMY0Y5SUVHN2EycWxy?= =?iso-2022-jp?B?UEQ4Sy9kNm9VeFhZZDFXZ3pXYTFTQnNOVzVrdkR4NXlmUWlTWU5nUEN1?= =?iso-2022-jp?B?SDRzbWVxQnBHUmRSWnFKSUVjczhBVUY1Tld5UWVUaXR2UlpVWVJ2VXJo?= =?iso-2022-jp?B?VzR2OVZBR29qejVKWmIrUHRJUno2MFBrRW1hR2RvTVQxMWZmcm42N01Q?= =?iso-2022-jp?B?OFk3ZlB3R1FrWVQzUTN0akhvckdpUURDNUZ0V0V3d1Y2ejd5eGNZcWNt?= =?iso-2022-jp?B?bjhlUE52a0d6WlFYUjhMbGhMZkZrWTRab3h2ZUlBeXpXb0FBYVZUVThH?= =?iso-2022-jp?B?UmltQnRaQmU0NmpCbUp3N1NqNnBxdkNrSnNmNFY5UkxTdzdyQVREdXEw?= =?iso-2022-jp?B?bnlFcVZUOUhTeWhpR2ZaNGwyc1RvVlFnUVF0RzZadWx6UXh6a0dwUEVo?= =?iso-2022-jp?B?KzJ0UGxxT2Yrd3UyQjhhckFUK3ZiaXRMcFQzQkZUT0o5cXZINXpKY1Er?= =?iso-2022-jp?B?UFNjanJkQndGVG1qVHJ3VTVGelhoQmhtNldXbTFPbGl4dkYzaVlmY2Fj?= =?iso-2022-jp?B?eWNSdUhsalRGVWJzbDdnNk4yTFZRTnlFaTExbS9XYS9JVCt6cE9OL3ow?= =?iso-2022-jp?B?UHVwcUdsaCttSUZTSFlLbzlONkQ5ell3QWc0aVo2aEp6bUdVRk1xVDJ1?= =?iso-2022-jp?B?N0hCNmxZSEJiZHUxTldDLzVSOWUyUjhndjZtd0hnbEIybHBWdXRRMFhu?= =?iso-2022-jp?B?amMvNFNIcFdRTVVzU3RnWVdFN0JnTDZvSWZwRWdERW9QT1p4T3dwdHg2?= =?iso-2022-jp?B?TUxrZGN0ak80ZTRHNXdwbzNhTitScnl4Q25iTEZxVFBVNXNXZEFXM1VM?= =?iso-2022-jp?B?S1N4SURxU2NmeHU5MU4yd0hsLytrZzhvVT0=?= Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: sraoss.co.jp X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: f142571f-cb44-4ed8-4857-08ddc4f3f570 X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Jul 2025 05:37:02.9948 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 75db6c32-352e-4063-ae79-cafb8623f6db X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 0uwDo9pYyUQCjEZRFp4O3z9Cj3+fzfH9zD1Rnyv6LQJV+Yk0aXG9gc+DQdjAhRHBODVuEe7KHrSlXZO4DS4A7Q== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS7P286MB5312 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Pushed to master branch:=0A= https://git.postgresql.org/gitweb/?p=3Dpgpool2.git;a=3Dcommit;h=3D3cc3d2d84= 8a9e0c0646961ab4fa7904fafac2d5f=0A= =0A= ________________________________________=0A= =1B$B:9=3DP?M=1B(B: Bo Peng =0A= =1B$BAw?.=1B(B: 2025 =1B$BG/=1B(B 6 =1B$B7n=1B(B 27 =1B$BF|=1B(B (=1B$B6bMK= F|=1B(B) 9:00=0A= =1B$B08@h=1B(B: pgpool-hackers@lists.postgresql.org =0A= =1B$B7oL>=1B(B: Proposal: make the online recovery database configurable=0A= =0A= =0A= Currently, the online recovery database is hardcoded to "template1".=0A= It would be helpful in some use cases to make this configurable.=0A= =0A= The attached patch adds a new configuration parameter, "recovery_database",= =0A= which allows the online recovery database to be configured.=0A= The default is set to "template1" for backward compatibility.=0A= =0A= Any suggestions on changing the default value to "postgres"?=0A= ---=0A= Bo Peng =0A= SRA OSS K.K.=0A= TEL: 03-5979-2701 FAX: 03-5979-2702=0A= URL: https://www.sraoss.co.jp/=0A= =0A=