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 1u32qW-009aLr-N1 for pgsql-committers@arkaria.postgresql.org; Fri, 11 Apr 2025 01:06:16 +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 1u32qU-002T1X-V4 for pgsql-committers@arkaria.postgresql.org; Fri, 11 Apr 2025 01:06:15 +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 1u32oV-002PiL-Va for pgsql-committers@lists.postgresql.org; Fri, 11 Apr 2025 01:04:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u32oT-004cRl-2T for pgsql-committers@lists.postgresql.org; Fri, 11 Apr 2025 01:04:11 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u32oS-003Dhp-6E for pgsql-committers@lists.postgresql.org; Fri, 11 Apr 2025 01:04:08 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u32oR-003fwI-2q for pgsql-committers@lists.postgresql.org; Fri, 11 Apr 2025 01:04:07 +0000 Content-Type: multipart/mixed; boundary="===============6946971120240737374==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix race with synchronous_standby_names at startup X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 11 Apr 2025 01:04:07 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6946971120240737374== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHJhY2Ugd2l0aCBzeW5jaHJvbm91c19zdGFuZGJ5X25hbWVzIGF0IHN0YXJ0dXAKCnN5bmNo cm9ub3VzX3N0YW5kYnlfbmFtZXMgY2Fubm90IGJlIHJlbG9hZGVkIHNhZmVseSBieSBiYWNrZW5k cywgYW5kIHRoZQpjaGVja3BvaW50ZXIgaXMgaW4gY2hhcmdlIG9mIHVwZGF0aW5nIGEgc3RhdGUg aW4gc2hhcmVkIG1lbW9yeSBpZiB0aGUKR1VDIGlzIGVuYWJsZWQgaW4gV2FsU25kQ3RsLCB0byBs ZXQgdGhlIGJhY2tlbmRzIGtub3cgaWYgdGhleSBzaG91bGQKd2FpdCBvciBub3QgZm9yIGEgZ2l2 ZW4gTFNOLiAgVGhpcyBwcm92aWRlcyBhIHN0cmljdCBjb250cm9sIG9uIHRoZQp0aW1pbmcgb2Yg dGhlIHdhaXRpbmcgcXVldWVzIGlmIHRoZSBHVUMgaXMgZW5hYmxlZCBvciBkaXNhYmxlZCwgdGhl bgpyZWxvYWRlZC4gIFRoZSBjaGVja3BvaW50ZXIgaXMgYWxzbyBpbiBjaGFyZ2Ugb2Ygd2FraW5n IHVwIHRoZSBiYWNrZW5kcwp0aGF0IGNvdWxkIGJlIHdhaXRpbmcgZm9yIGEgTFNOIHdoZW4gdGhl IEdVQyBpcyBkaXNhYmxlZC4KClRoaXMgbG9naWMgaGFkIGEgcmFjZSBjb25kaXRpb24gYXQgc3Rh cnR1cCwgd2hlcmUgaXQgd291bGQgYmUgcG9zc2libGUKZm9yIGJhY2tlbmRzIHRvIG5vdCB3YWl0 IGZvciBhIExTTiBldmVuIGlmIHN5bmNocm9ub3VzX3N0YW5kYnlfbmFtZXMgaXMKZW5hYmxlZC4g IFRoaXMgd291bGQgY2F1c2UgdmlzaWJpbGl0eSBpc3N1ZXMgd2l0aCB0cmFuc2FjdGlvbnMgdGhh dCB3ZQpzaG91bGQgYmUgd2FpdGluZyBmb3IgYnV0IHRoZXkgd2VyZSBub3QuICBUaGUgcHJvYmxl bSBsYXN0cyB1bnRpbCB0aGUKY2hlY2twb2ludGVyIGRvZXMgaXRzIGluaXRpYWwgdXBkYXRlIG9m IHRoZSBzaGFyZWQgbWVtb3J5IHN0YXRlIHdoZW4gaXQKbG9hZHMgc3luY2hyb25vdXNfc3RhbmRi eV9uYW1lcy4KCkluIG9yZGVyIHRvIHRha2UgY2FyZSBvZiB0aGlzIHByb2JsZW0sIHRoZSBzaGFy ZWQgbWVtb3J5IHN0YXRlIGluCldhbFNuZEN0bCBpcyBleHRlbmRlZCB0byBkZXRlY3QgaWYgaXQg aGFzIGJlZW4gaW5pdGlhbGl6ZWQgYnkgdGhlCmNoZWNrcG9pbnRlciwgYW5kIG5vdCBvbmx5IGNo ZWNrIGlmIHN5bmNocm9ub3VzX3N0YW5kYnlfbmFtZXMgaXMKZGVmaW5lZC4gIEluIFdhbFNuZEN0 bERhdGEsIHN5bmNfc3RhbmRieXNfZGVmaW5lZCBpcyByZW5hbWVkIHRvCnN5bmNfc3RhbmRieXNf c3RhdHVzLCBhIGJpdHM4IGFibGUgdG8ga25vdyBhYm91dCB0d28gc3RhdGVzOgotIElmIHRoZSBz aGFyZWQgbWVtb3J5IHN0YXRlIGhhcyBiZWVuIGluaXRpYWxpemVkLiAgVGhpcyBmbGFnIGlzIHNl dCBieQp0aGUgY2hlY2twb2ludGVyIGF0IHN0YXJ0dXAgb25jZSwgYW5kIG5ldmVyIHJlbW92ZWQu Ci0gSWYgc3luY2hyb25vdXNfc3RhbmRieV9uYW1lcyBpcyBrbm93biBhcyBkZWZpbmVkIGluIHRo ZSBzaGFyZWQgbWVtb3J5CnN0YXRlLiAgVGhpcyBpcyB0aGUgc2FtZSBhcyB0aGUgcHJldmlvdXMg c3luY19zdGFuZGJ5c19kZWZpbmVkIGluCldhbFNuZEN0bC4KClRoaXMgbWV0aG9kIGdpdmVzIGEg d2F5IGZvciBiYWNrZW5kcyB0byBkZWNpZGUgd2hhdCB0aGV5IHNob3VsZCBkbyB1bnRpbAp0aGUg c2hhcmVkIG1lbW9yeSBhcmVhIGlzIGluaXRpYWxpemVkLCBhbmQgdGhleSBub3cgdWx0aW1hdGVs eSBmYWxsIGJhY2sKdG8gYSBjaGVjayBvbiB0aGUgR1VDIHZhbHVlIGluIHRoaXMgY2FzZSwgd2hp Y2ggaXMgdGhlIGJlc3QgdGhpbmcgdGhhdApjYW4gYmUgZG9uZS4KCkZvcnR1bmF0ZWx5LCBTeW5j UmVwVXBkYXRlU3luY1N0YW5kYnlzRGVmaW5lZCgpIGlzIGNhbGxlZCBpbW1lZGlhdGVseSBieQp0 aGUgY2hlY2twb2ludGVyIHdoZW4gdGhpcyBwcm9jZXNzIHN0YXJ0cywgc28gdGhlIHdpbmRvdyBp cyB2ZXJ5IG5hcnJvdy4KSXQgaXMgcG9zc2libGUgdG8gZW5sYXJnZSB0aGUgcHJvYmxlbWF0aWMg d2luZG93IGJ5IG1ha2luZyB0aGUKY2hlY2twb2ludGVyIHdhaXQgYXQgdGhlIGJlZ2lubmluZyBv ZiBTeW5jUmVwVXBkYXRlU3luY1N0YW5kYnlzRGVmaW5lZCgpCndpdGggYSBoYXJkY29kZWQgc2xl ZXAgZm9yIGV4YW1wbGUsIGFuZCBkb2luZyBzbyBoYXMgc2hvd2VkIHRoYXQgYSAyUEMKdmlzaWJp bGl0eSB0ZXN0IGlzIGluZGVlZCBmYWlsaW5nLiAgT24gbWFjaGluZXMgc2xvdyBlbm91Z2gsIHRo aXMgYnVnCndvdWxkIGNhdXNlIHNwdXJpb3VzIGZhaWx1cmVzLgoKSW4gMTd+LCB3ZSBoYXZlIGxv b2tlZCBhdCB0aGUgcG9zc2liaWxpdHkgb2YgYWRkaW5nIGFuIGluamVjdGlvbiBwb2ludAp0byBo YXZlIGEgcmVwcm9kdWNpYmxlIHRlc3QsIGJ1dCBhcyB0aGUgcHJvYmxlbWF0aWMgd2luZG93IGhh cHBlbnMgYXQKZWFybHkgc3RhcnR1cCwgd2Ugd291bGQgbmVlZCB0byBpbnZlbnQgYSB3YXkgdG8g bWFrZSBhbiBpbmplY3Rpb24gcG9pbnQKb3B0aW9uYWxseSBwZXJzaXN0ZW50IGFjcm9zcyByZXN0 YXJ0cyB3aGVuIGF0dGFjaGVkLCBzb21ldGhpbmcgdGhhdAp3b3VsZCBiZSBmaW5lIGZvciB0aGlz IGNhc2UgYXMgaXQgd291bGQgaW52b2x2ZSB0aGUgY2hlY2twb2ludGVyLiAgVGhpcwppc3N1ZSBp cyBxdWl0ZSBvbGQsIGFuZCBjYW4gYmUgcmVwcm9kdWNlZCBvbiBhbGwgdGhlIHN0YWJsZSBicmFu Y2hlcy4KCkF1dGhvcjogTWVsbmlrb3YgTWFrc2ltIDxtLm1lbG5pa292QHBvc3RncmVzcHJvLnJ1 PgpDby1hdXRob3JlZC1ieTogTWljaGFlbCBQYXF1aWVyIDxtaWNoYWVsQHBhcXVpZXIueHl6PgpE aXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE2M2ZjYmVjLTkwMGItNGIwNy1iZWFhLWQy ZWFkODYzNGJlY0Bwb3N0Z3Jlc3Byby5ydQpCYWNrcGF0Y2gtdGhyb3VnaDogMTMKCkJyYW5jaAot LS0tLS0KUkVMXzE3X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVz cWwub3JnL3BnL2NvbW1pdGRpZmYvMzMzOTg0N2NjZGUwMTllNmU2OTFjOWQ0Y2FlYzQ3MzZjMDYy NzdiZgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvcmVwbGljYXRp b24vc3luY3JlcC5jICAgICAgICAgICB8IDk3ICsrKysrKysrKysrKysrKysrKysrKysrKy0tLS0t CnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL3dhbHNlbmRlci5jICAgICAgICAgfCAgNiArLQpzcmMv aW5jbHVkZS9yZXBsaWNhdGlvbi93YWxzZW5kZXJfcHJpdmF0ZS5oIHwgMjMgKysrKystLQozIGZp bGVzIGNoYW5nZWQsIDEwNCBpbnNlcnRpb25zKCspLCAyMiBkZWxldGlvbnMoLSkKCg== --===============6946971120240737374==--