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 1uygjw-00BP4f-Iy for pgpool-general@arkaria.postgresql.org; Wed, 17 Sep 2025 01:13:45 +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 1uygju-003n1m-IV for pgpool-general@arkaria.postgresql.org; Wed, 17 Sep 2025 01:13:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uygjt-003mzG-Sa for pgpool-general@lists.postgresql.org; Wed, 17 Sep 2025 01:13:43 +0000 Received: from mail-tycjpn01on20713.outbound.protection.outlook.com ([2a01:111:f403:2019::713] helo=JPN01-TYC-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uygjs-000odi-04 for pgpool-general@lists.postgresql.org; Wed, 17 Sep 2025 01:13:41 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=HDN2thqyxKUW4H25qbbntoM8Qp5fDn+9kng37iNGE2ptPP7apZdLa+Kr0RTh3nCu/hAji/Qu+H3CtFrFIk95I/m4ULdS7iWaKJcQUM1GKW/QLjhmEg1VD/CwQvaqOboCEE6C7O3yOBX0IWDltqQanQHz+iY7gqnuJVlt+cCyocDnkjdl3istFiDE/5IWVjN8+Zm3A7SUfKyh5ZDPefErFmNeTMqSWxcpnz8fOzeUy//nN6ZxMSzb/NoG86odBxH7EHYrEIkt/mh6HHEemudcQxtR9S2he7ppbSjah9loXWIILpesRiYhunXPpAcs0PcWIsDqERNFF67+YL08ZknUww== 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=C12jOZ5cB+Zgg/P8uiSxbEJE7T1Npu5r299VIDZKkdE=; b=BzFUkaDO0NxUUsJ1wyL5lIgChv8UY1zH3yP4nkqfb4dFcy8eXz4/1qzhjDCmV7gZ7zKNROxqVJEJlxYjmgXsgzxBAKoLhQGXJdFe2aswuyJ/fQVYNXT6m/B4KFluJHaPfFwBjzXmOEKSpLr3VGBsUKYOfYkpwvXRyzs34HB4rMG1qEo8CgJdY9/NF8lJq+eiljD1MMTQekOckAb01Ad3GJxj1dxElI7ohJHWmKBg9zE/pzOjbutnAy7uNz81SEJd6mRD00KCJT0e8SgpSfZrDqARS03ZCWCkt6bvFvveqosavSpbHPxVtSaC4e2uuvqCba1htOOFs3Jzq9Uwvlbmxw== 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=C12jOZ5cB+Zgg/P8uiSxbEJE7T1Npu5r299VIDZKkdE=; b=jj0tr5b1t680FBn9/rMU9sQvX92+iMt2um/kn6NfDx5aT6++FP7CN2lon9RhLKweA771vhEO6SsI15rSAecoUwLB+B+pydhtWj+Z+2sObU8Pl5UW4v/hKpNCo684ScvifEtvg+kjhhMRSDg6Ejw10Ldtoa0H8A9Vt+aQPbs1LJ6+fEU1iu0IW3PoDNfzDkT9LlOm2yZytHDJBMbzID/n/R6mWVW7mXnk8JfCoLnnYFijmbhreAFvCu/6h4ARNHtjZjVTqhfyn3TBMFUAAkEWB+mxNe+U7j5dUEOgK62oMUEMlW7z53/jnt0bndCQ3ujzuUKDpzS+Mv58Mzr9Sn9JhA== Received: from TYCP286MB2926.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:309::10) by TY4P286MB6942.JPNP286.PROD.OUTLOOK.COM (2603:1096:405:33e::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9137.13; Wed, 17 Sep 2025 01:13:34 +0000 Received: from TYCP286MB2926.JPNP286.PROD.OUTLOOK.COM ([fe80::396c:37a1:5a85:469d]) by TYCP286MB2926.JPNP286.PROD.OUTLOOK.COM ([fe80::396c:37a1:5a85:469d%6]) with mapi id 15.20.9115.022; Wed, 17 Sep 2025 01:13:34 +0000 From: Koshino Taiki To: Macao Tom CC: "pgpool-general@lists.postgresql.org" Subject: Re: About pgpool failover / switchover Thread-Topic: About pgpool failover / switchover Thread-Index: AQHcI7Wxzux0SKABcUaO2hIh/7OA37SWld2S Date: Wed, 17 Sep 2025 01:13:34 +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: TYCP286MB2926:EE_|TY4P286MB6942:EE_ x-ms-office365-filtering-correlation-id: 5af75fec-171f-4115-6f0a-08ddf5876c37 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|13003099007|38070700021|8096899003|7053199007; x-microsoft-antispam-message-info: =?big5?B?Rmhib25JSUZKeTBEa2hVdHRMTGhDR0ErUTB4SzN6ZTYxTGpVeEdSNmY1QWswWUls?= =?big5?B?ZFJMRjhCUWFEMEV2YUUzYW1oOUkyUkZKMVQzQmhnQVRTZ240QmMwT2JMcmNSY01L?= =?big5?B?MFhmUVQvT0t2YW9WRXRLNEIvYlhmM1kzSldLQ1pqTE1OVEhVMXkvek5oN0daSllm?= =?big5?B?Tzl1VEhid29ZWEVZSG1nQysrSjBoT1JZb0s1TlJNNUN1a1ZFYXc4NmYvQmRvVytN?= =?big5?B?SndoayttdHpPZUp1ZDhDQlNnWlh2S1hjRGMrRzJqeXlndXhZcE42UkZxSThJcSts?= =?big5?B?Ky9ZOU1KR3RsK1dOYVJUdDFEMmQ5Y1EwL1RjZm50V1FtSkhaV3JTK29EVW5xaEVP?= =?big5?B?djlDR0xMSHU5SDZpYUMxUndPeGF4SGxFcFFsbE5tZlErQVlRNFlvM2NLSWRMVklJ?= =?big5?B?dlN1QTJPOC81dHV6Q1VVMmtrNDA5dWt3ZFpxV3U0Nmprd0JuNFJ2UnNHOEtoZ0RX?= =?big5?B?dVQxdmJmTllkSGZnSWRtRU52TDhGMkN3dlZsSEpSS2w4Uzh3dnNONk9Ic3JpRSsz?= =?big5?B?dTlST1NYNytQK1RjT2dmaDQ4emV0dWlFQjN6bEVVRHFseVZTeTZEVXpYcS94OFd3?= =?big5?B?MW5lMDF1WW9RUVJJaVZhUk5MQW15ZVhZN1NPWnVxaEZlUExWelpOd2x0MW5wd2RC?= =?big5?B?dkl2QkxGSi9NOXF1OWZsMG0vRXQrSU5OZ2NvM0k0U1JKUVEzcG9SYXlIZTBVcEZi?= =?big5?B?TmtUUDh6ZVdzWUpnZ0JuVGt3SkZZMTAxbXpIZ3FkMUNkSm9HSm5Kdk5HU1RkR1RV?= =?big5?B?ZUVlVDNubnlwZkVIdmM5bmROb3pCOWoxS2FlajBYNVN6VEpBWHRqOHZmZVBqeXRw?= =?big5?B?aS9HTExWalNta0lRQVlKZFV1QlJ4VVJSWFRMbmh3amdqSWZSM0VMQjRVTlNWTzNp?= =?big5?B?S3ZIOWU1WEE2QlJGYmFEQlBjUXpneis4Z2FEMjN6UHF3YW9WbTJ4cnV3SUtrdXQw?= =?big5?B?ZHRldFVqSHdCZzNrZk1Dc2NxdXRDcTJDR3ozMkN5Zm4zT3ZMNmVwRjJKZit0cVpB?= =?big5?B?WGd2VkxRM1ZhSTR6NlRmZnhzbnFhR0FIZ3BKMkVCdTZ3cXZIa2ZESitKTHZNbmZT?= =?big5?B?ZjdkYjkrOVZZRjBuMHVwN0NsS2gxWU05Y0RYZDl6aDV0ajVYdm5qWTdjeEdQb2ts?= =?big5?B?Rk9VN2VFRUI3M1FrMUtCM0haS1dtN09TcFNIY1BtUFFLVDBDWStQM1IwdUhNaXRQ?= =?big5?B?Y1BXTzRWMWZXYUp0Q0tJRGhqV3gvMnZKRXc1Z2psNXZuWlFqVnFDdWFyV0hHY3E1?= =?big5?B?MURjU3A1a08vMWlTVmtsVjY5LzFMZzZ1VXZzeWJ1YW1Ob0RPOHdWYjZUOWxUQk9p?= =?big5?B?MkNCZkdjZ2JLc2RIK0loQktiUTlETVhhczRQVUI3VzY2T0UzMTZ3VXZERVBSTWpo?= =?big5?B?N1gyelJwMkpDR0M1ZWFrMnVVUnpJYnZQdm9zOGZRaENISjh5Q0krYmpXZ09FVU5y?= =?big5?B?OCtOcmhqdTIzVlVnSVppRXRMWlFvY1I3OG1tcTZLUFpPWnZ2cEFiV090NXQzaTdO?= =?big5?B?TTQyTVRkUFBUNlhOMTJsMk1wR1E4NVJqd0d3U2lZTld1d2JiUFVhc3c3UjhQa29q?= =?big5?B?ejZHd1l1YUNNU3c1UHVadzlDUXVKc2FYdkJTV2MxVm5oTzMwVEN5ekpKSEhOQnRU?= =?big5?B?SWowR0xLMS9XdlFYSVdmazF0V0JsOS9mT0JFY25EOEEzUG5Cc1pmWXJHWHdNUzhr?= =?big5?B?bmhPcjFRZTgyMmxOL2RYZVdNcWZtcDlURGFSSjNneWNjd2VUS29sSVFaY2liOS93?= =?big5?B?NVlKM0hwWW9NVHNma1lKZ01Bb2xYRVI1NlBud1RESm8xVGcyeGw0SVlMTDl5ekFX?= =?big5?Q?4RXxtz6hYNk=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:zh-tw;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYCP286MB2926.JPNP286.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(13003099007)(38070700021)(8096899003)(7053199007);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?big5?B?dUV2UXdWcVQwbzFjbG9yNEJaVWNLYlZFeWZORGF4aDlqUHZYTDI3VEZCbS82V0Zt?= =?big5?B?S2psM0VnVE12L0RoQXRyVVBVQVhEbTIwYk9OYklzbE1kY2RDV1g5T3dJT0dMTjAy?= =?big5?B?RlhuNkN1dmcxUWFaUW84TGVBcVFLYzlSb0FUZFozclpvSFNBWDNPcitQNlBWKys4?= =?big5?B?cDJSOXB0dFFuWEJoTmU5MUZHZHBqUG9UOXVHRzNmWXZMeWVGNFpOYWtDdlNIM0xH?= =?big5?B?TEVWRWpyYk9XeWxraEZQdlRza0JGQytJSVF1dkFYUU9Rem5LaFpCeHEyL0ppbVZt?= =?big5?B?YXVTbGVEV29hb1dYNi8wQmdrak1Ydno5Ylg4WW16UFc4YXVBYy9QaE5SbkxxT3Y0?= =?big5?B?bGtFRzRuOGFHRzVvR1FzUStxNEZxK3ZvMGdCWG8wcWw0VEVsZ0YvdGZFR0xlcWpW?= =?big5?B?VktVeEkyclJDYXl0Z2pKNzdPRXE4V2U3NlA2bVEraFlIdkpzUTRYcWptankvMmFV?= =?big5?B?STR2N2loc1M2enMwR0FGUi9PQmdjdDJuTEFEZ20zOXRDMHZOc2VqdG9QSFJpMDBP?= =?big5?B?MS9HWWVWZS9IMyt5UmMyNEhqQ1E1TlJySTZrVHYrWkZZL0lWVTlPOWpUNytuaEZL?= =?big5?B?OXJCWUh0RmhraWVBR2tBdjdsZG5paXlhczR5cUoxQzZqc051OTVONnBrdHNteS9L?= =?big5?B?TG1MSFVUc1hIQmpJZlJ1Q0NpVGRjQW4zYXRJK092KzNGaE5iS2dDcU1aUjRqRTRE?= =?big5?B?c2JsS0JUaWFudHFpM3VLalJHWkJHZVZYT1ZBZU1KaW5xblVGTTkxanV4T1I5WkdG?= =?big5?B?WDVLRGNwa1pwMXlTVkh5Yk1hb01jY0RkZEdXQi96V3E1M0s0cjRLL0dOeTRaNHNI?= =?big5?B?d0UrejVkMDhTWElFK2tjWWFhUkxaNDl2YTJRc0tPejl6aEVyd2ZMcjJDdnVNZzBW?= =?big5?B?ZjRnckZPYmZVNWNSeGl4eXI1anBQazFNQTBISHVSRkQvdFh5SkJyOEt6QmdpVk5k?= =?big5?B?YWNyOHlhTmhGbk5xUmM2WitmT3V0cDBLbXhQYlZWeUtrMms3dGl5ZUNmRlprVE02?= =?big5?B?YytGVlBhbCsxc0dYNjZkbXNDM3Q1d2VnMWpYcUVuZkJqb2N0T3YrK1QyVWxDeWcv?= =?big5?B?SHV5YnNRUkxoa3FwMVNPNXRnS3ZpbDNkYS90b2w4MldqM2hMbUxmVDJ5ellzZURJ?= =?big5?B?Y1IxWUs5OUpoc25aQXhpdG9CR0FLVUpHV3RNL0g3S2Q5NTd1SUlDZ1ZKbm9hMTlP?= =?big5?B?Rmp3eXROVWRFWEQyaWFnQVpmQmxrcUEraGRPd3NKQTNGOG5FUjVxeC9CaXQ4TWpO?= =?big5?B?SFJwUzRkaW1YWGREK2VHT3BjSjRCT2VGeXRyZXNsNGQ3U3J1am90OTEvNk05OEM4?= =?big5?B?SlZjQ1c0YkExQ1FvcXRBVjdHUGFubWpqeEtEMWxkWWc3dWxvaFo5WVV4bzJCc3Jh?= =?big5?B?KzkxSWwrYzl2cEtKNURGVy9mbzhFRmJTdjM2aGFmbm5udlV2VmMxK2NZZ3BUUXJC?= =?big5?B?bjdUcnlTa3dVWkc1T2xMeXFTZFpqQzdkcmNYTlBRUEJOZTMzY2FiTHM3Q3NEaUI3?= =?big5?B?UE1BMGJkaUdpL2VvTVRzbWxNY29wd0VENXZ6azF1SlVhS0YrWWFVSnlkaHJqTmxL?= =?big5?B?ZHRLYzFYYklFbkxUWVFzUTV5Q1NsVGdZVGsxZHh5NFpCcSt0TkQrSG5icTNJd1BE?= =?big5?B?SVFvaENrQmw2RHNuWWQxbW5VYXRYMXp6NzE4enJGMnRvRlhRQnoxTmZVYmg4eVBB?= =?big5?B?RW9YeEFRTWhOWnQ1eVFjcHd5NmtraDI3ZlNFUHhuSG9PVWRaL0UrN0ljMnJobTJ0?= =?big5?B?d1RlMVh3Z0ZUT0FWMnZWWW51SG9Ob3JzMHNRdDdWcVFRaE5BUllSSk54ZXZWZmMx?= =?big5?B?dEdaTkgvMW9Yb0twK1lDTEltVmtGOXBPbGFIbU43NE1WNVRJc1BjNklNZ1JrdkNM?= =?big5?B?OTNhaEJPQ1BlMzR3TDhoUVB2ZUdtNTh6Vk9zcmVpRFdTVDNVb3l0b051QmZDV2t0?= =?big5?B?b3BtZjVzUStjL2l1SDdseSs4Qnd5aGd1QUtWb0MrTm9Ockg4by8zeWhGdGRIRVhY?= =?big5?Q?1Lb9ucmXjgR8nXhU?= Content-Type: multipart/alternative; boundary="_000_TYCP286MB2926C37D1EB8D8E2D882DA819417ATYCP286MB2926JPNP_" MIME-Version: 1.0 X-OriginatorOrg: sraoss.co.jp X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYCP286MB2926.JPNP286.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 5af75fec-171f-4115-6f0a-08ddf5876c37 X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Sep 2025 01:13:34.1044 (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: 2vOcjUOF9wNb5B6J7VuE6ixv4RXUJz350N12gClNAgLCmkVFn/Jc6KP4ciYgHU60a+IvfxVNKVQgN51b8QPr8w== X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY4P286MB6942 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_TYCP286MB2926C37D1EB8D8E2D882DA819417ATYCP286MB2926JPNP_ Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: base64 VGhpcyBpcyBiZWNhdXNlLCB3aGVuIGEgZmFpbG92ZXIgb3Igc3dpdGNob3ZlciBvY2N1cnMgYW5k IHRoZSBwcmltYXJ5IGNoYW5nZXMsIFBncG9vbC1JSSB1cGRhdGVzICRQR0RBVEEvbXlyZWNvdmVy eS5jb25mIGluc3RlYWQgb2YgcG9zdGdyZXNxbC5hdXRvLmNvbmYuDQoNCldoZW4gYSBzdGFuZGJ5 IGNvbm5lY3RzIHRvIHRoZSBwcmltYXJ5LCBpdCByZWZlcnMgdG8gdGhlIGluZm9ybWF0aW9uIGlu IHBvc3RncmVzcWwuYXV0by5jb25mICwgaWYgdGhlIHNldHRpbmcgZXhpc3RzIHRoZXJlLg0KSG93 ZXZlciwgZHVyaW5nIGZhaWxvdmVyIG9yIHN3aXRjaG92ZXIsIFBncG9vbC1JSSB1cGRhdGVzICRQ R0RBVEEvbXlyZWNvdmVyeS5jb25mIHJhdGhlciB0aGFuIHBvc3RncmVzcWwuYXV0by5jb25mLg0K QXMgYSByZXN1bHQsIHBvc3RncmVzcWwuYXV0by5jb25mIHN0aWxsIGNvbnRhaW5zIG91dGRhdGVk IGNvbm5lY3Rpb24gaW5mb3JtYXRpb24sIGNhdXNpbmcgUG9zdGdyZVNRTCB0byBhdHRlbXB0IHRv IGNvbm5lY3QgdXNpbmcgdGhpcyB3cm9uZyBpbmZvcm1hdGlvbiwgd2hpY2ggbGVhZHMgdG8gY29u bmVjdGlvbiBmYWlsdXJlcy4NCg0KSW4gdGhpcyBjYXNlLCBieSBkZWxldGluZyBwb3N0Z3Jlc3Fs LmF1dG8uY29uZiwgdGhlIHByaW1hcnlfY29ubmluZm8gaW4gJFBHREFUQS9teXJlY292ZXJ5LmNv bmYgd2FzIHVzZWQsIHdoaWNoIHdhcyBjb3JyZWN0LCBzbyB0aGUgY29ubmVjdGlvbiBzdWNjZWVk ZWQuDQoNClNpbmNlIGhhdmluZyBwcmltYXJ5X2Nvbm5pbmZvIGluIHBvc3RncmVzcWwuYXV0by5j b25mIGNhbiBzb21ldGltZXMgcHJldmVudCBwcm9wZXIgY29ubmVjdGlvbnMsIGl0IGlzIGdlbmVy YWxseSByZWNvbW1lbmRlZCBub3QgdG8gaW5jbHVkZSBwcmltYXJ5X2Nvbm5pbmZvIGluIHBvc3Rn cmVzcWwuYXV0by5jb25mLg0KDQpUYWlraSBLb3NoaW5vPGtvc2hpbm9Ac3Jhb3NzLmNvLmpwPg0K U1JBIE9TUyBLLksuDQpURUw6IDAzLTU5NzktMjcwMSBGQVg6IDAzLTU5NzktMjcwMg0KVVJMOiBo dHRwczovL3d3dy5zcmFvc3MuY28uanAvDQoNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fDQqudKVYpEg6IE1hY2FvIFRvbSA8bWFjYW90b21AZ21haWwuY29tPg0KsGWrSKTprsk6IDIw MjWmfjmk6zEypOkgMTI6NDMNCql7pf06IHBncG9vbC1nZW5lcmFsQGxpc3RzLnBvc3RncmVzcWwu b3JnIDxwZ3Bvb2wtZ2VuZXJhbEBsaXN0cy5wb3N0Z3Jlc3FsLm9yZz4NCqXzplc6IEFib3V0IHBn cG9vbCBmYWlsb3ZlciAvIHN3aXRjaG92ZXINCg0KRGVhciBwZ3Bvb2wsDQoNCkkgYnVpbHQgdXAg YSBwb3N0Z3Jlc3FsIDE3LjYuMiAzIG5vZGVzIGNsdXN0ZXIgd2l0aCAzIHBncG9vbCA0LjYuMiAs IHdoZW4gSSB0cnkgdG8gc3dpdGNoIG92ZXIgdXNpbmcgoadwY3BfcHJvbW90ZV9zdGFydCAtcyCh Sy4uoaggaXQgc2VlbXMgb3RoZXIgc3RhbmR5IG5vZGVzIGNhbiBub3QgZm9sbG93IHRoZSBuZXcg cHJpbWFyeSBub2RlLiBIb3dldmVyLCBhZnRlciBJIHJlbW92ZSB0aGUgoadwb3N0Z3Jlcy5hdXRv LmNvbmahqCBpbiBlYWNoIHNlcnZlciBhbmQgc3dpdGNoIG92ZXIgdXNpbmcgdGhlIHNhbWUgY29t bWFuZCBhZ2FpbiwgaXQgd29ya3MuIEkgaGF2ZSBhbHNvIGNoZWNrIHdoYXQgc3RvcmUgaW4goadw b3N0Z3Jlcy5hdXRvLmNvbmahqCwgaXQgbWF5IHN0b3JlIG1hbnkgY29uZmlnIGxpa2Ugoadwcmlt YXJ5X2Nvbm5faW5mb6GoIHdoaWNoIGNvbm5lY3QgdG8gdGhlIG9sZCBwcmltYXJ5Lg0KDQpEbyB5 b3UgaGF2ZSBhbnkgaWRlYSBhYm91dCB0aGlzPyBPciBkbyB5b3Uga25vdyB3aGF0IG1lY2hhbmlz bSBjYXVzZSBwb3N0Z3JlcyBzdG9yZSB0aGUgb2xkIHByaW1hcnkgaW5mbyBpbiChp3Bvc3RncmVz LmF1dG8uY29uZmlnoaggZmlsZT8NCg0KQmVzdCByZWdhcmRzLA0KVGVyZW5jZQ0K --_000_TYCP286MB2926C37D1EB8D8E2D882DA819417ATYCP286MB2926JPNP_ Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable
This is because, when a failover or switchover occurs and the primary chang= es, Pgpool-II updates $PGDATA/myrecovery.conf instead of postgresql.auto.co= nf. 

When a standby connects to the primary, it refers to the information in pos= tgresql.auto.conf , if the setting exists there.
However, during failover or switchover, Pgpool-II updates $PGDATA/myrecover= y.conf rather than postgresql.auto.conf.
As a result, postgresql.auto.conf still contains outdated connection inform= ation, causing PostgreSQL to attempt to connect using this wrong informatio= n, which leads to connection failures.

In this case, by deleting postgresql.auto.conf, the primary_conninfo in $PG= DATA/myrecovery.conf was used, which was correct, so the connection succeed= ed.

Since having primary_conninfo in postgresql.auto.conf can sometimes prevent= proper connections, it is generally recommended not to include primary_con= ninfo in postgresql.auto.conf.

Taiki Koshino<koshino@sraoss.co.= jp>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/

=AEt=A5X=A4H: Macao Tom <= ;macaotom@gmail.com>
=B0e=ABH=A4=E9=AE=C9: 2025=A6~9=A4=EB12=A4=E9 12:43
=A9{=A5=FD: pgpool-general@lists.postgresql.org <pgpool-general@l= ists.postgresql.org>
=A5=F3=A6W: About pgpool failover / switchover
 
Dear pgpool,

I built up a postgresql 17.6.2 3 nodes cluster with 3 pgp= ool 4.6.2 , when I try to switch over using =A1=A7pcp_promote_start -s =A1K= ..=A1=A8 it seems other standy nodes can not follow the new primary node. H= owever, after I remove the =A1=A7postgres.auto.conf=A1=A8 in each server and switch over using the same command again, it works. I h= ave also check what store in =A1=A7postgres.auto.conf=A1=A8, it may store m= any config like =A1=A7primary_conn_info=A1=A8 which connect to the old prim= ary.

Do you have any idea about this? Or do you know what mech= anism cause postgres store the old primary info in =A1=A7postgres.auto.conf= ig=A1=A8 file?

Best regards,
Terence
--_000_TYCP286MB2926C37D1EB8D8E2D882DA819417ATYCP286MB2926JPNP_--