Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pl2j8-0004uC-MC for pgsql-committers@arkaria.postgresql.org; Sat, 08 Apr 2023 07:11:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pl2j6-0007Vz-2M for pgsql-committers@arkaria.postgresql.org; Sat, 08 Apr 2023 07:11:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pl2j5-0007Vq-RW for pgsql-committers@lists.postgresql.org; Sat, 08 Apr 2023 07:11:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pl2j1-0006Fs-3B for pgsql-committers@lists.postgresql.org; Sat, 08 Apr 2023 07:11:06 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pl2j0-0005FR-CU for pgsql-committers@lists.postgresql.org; Sat, 08 Apr 2023 07:11:02 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pl2iy-0020Hl-7X for pgsql-committers@lists.postgresql.org; Sat, 08 Apr 2023 07:11:01 +0000 Content-Type: multipart/mixed; boundary="===============8795724329938134553==" MIME-Version: 1.0 From: Andres Freund To: pgsql-committers@lists.postgresql.org Subject: pgsql: Handle logical slot conflicts on standby X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 08 Apr 2023 07:11:01 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8795724329938134553== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGFuZGxlIGxvZ2ljYWwgc2xvdCBjb25mbGljdHMgb24gc3RhbmRieQoKRHVyaW5nIFdBTCByZXBs YXkgb24gdGhlIHN0YW5kYnksIHdoZW4gYSBjb25mbGljdCB3aXRoIGEgbG9naWNhbCBzbG90IGlz CmlkZW50aWZpZWQsIGludmFsaWRhdGUgc3VjaCBzbG90cy4gVGhlcmUgYXJlIHR3byBzb3VyY2Vz IG9mIGNvbmZsaWN0czoKMSkgVXNpbmcgdGhlIGluZm9ybWF0aW9uIGFkZGVkIGluIDZhZjE3OTM5 NTRlLCBsb2dpY2FsIHNsb3RzIGFyZSBpbnZhbGlkYXRlZCBpZgogICByZXF1aXJlZCByb3dzIGFy ZSByZW1vdmVkCjIpIHdhbF9sZXZlbCBvbiB0aGUgcHJpbWFyeSBzZXJ2ZXIgaXMgcmVkdWNlZCB0 byBiZWxvdyBsb2dpY2FsCgpVc2VzIHRoZSBpbmZyYXN0cnVjdHVyZSBpbnRyb2R1Y2VkIGluIHRo ZSBwcmlvciBjb21taXQuIEZJWE1FOiBhZGQgY29tbWl0CnJlZmVyZW5jZS4KCkNoYW5nZSBJbnZh bGlkYXRlUG9zc2libHlPYnNvbGV0ZVNsb3QoKSB0byB1c2UgYSByZWNvdmVyeSBjb25mbGljdCB0 bwppbnRlcnJ1cHQgdXNlIG9mIGEgc2xvdCwgaWYgY2FsbGVkIGluIHRoZSBzdGFydHVwIHByb2Nl c3MuIFRoZSBuZXcgcmVjb3ZlcnkKY29uZmxpY3QgaXMgYWRkZWQgdG8gcGdfc3RhdF9kYXRhYmFz ZV9jb25mbGljdHMsIGFzIGNvbmZsX2FjdGl2ZV9sb2dpY2Fsc2xvdC4KClNlZSA2YWYxNzkzOTU0 ZSBmb3IgYW4gb3ZlcmFsbCBkZXNpZ24gb2YgbG9naWNhbCBkZWNvZGluZyBvbiBhIHN0YW5kYnku CgpCdW1wcyBjYXR2ZXJzaW9uIGZvciB0aGUgYWRkaXRpb24gb2YgdGhlIHBnX3N0YXRfZGF0YWJh c2VfY29uZmxpY3RzIGNvbHVtbi4KQnVtcHMgUEdTVEFUX0ZJTEVfRk9STUFUX0lEIGZvciB0aGUg c2FtZSByZWFzb24uCgpBdXRob3I6ICJEcm91dm90LCBCZXJ0cmFuZCIgPGJlcnRyYW5kZHJvdXZv dC5wZ0BnbWFpbC5jb20+CkF1dGhvcjogQW5kcmVzIEZyZXVuZCA8YW5kcmVzQGFuYXJhemVsLmRl PgpBdXRob3I6IEFtaXQgS2hhbmRla2FyIDxhbWl0ZGtoYW4ucGdAZ21haWwuY29tPiAoaW4gYW4g b2xkZXIgdmVyc2lvbikKUmV2aWV3ZWQtYnk6ICJEcm91dm90LCBCZXJ0cmFuZCIgPGJlcnRyYW5k ZHJvdXZvdC5wZ0BnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBBbmRyZXMgRnJldW5kIDxhbmRyZXNA YW5hcmF6ZWwuZGU+ClJldmlld2VkLWJ5OiBSb2JlcnQgSGFhcyA8cm9iZXJ0bWhhYXNAZ21haWwu Y29tPgpSZXZpZXdlZC1ieTogRmFicsOtemlvIGRlIFJveWVzIE1lbGxvIDxmYWJyaXppb21lbGxv QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEJoYXJhdGggUnVwaXJlZGR5IDxiaGFyYXRoLnJ1cGly ZWRkeWZvcnBvc3RncmVzQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEFtaXQgS2FwaWxhIDxhbWl0 LmthcGlsYTE2QGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEFsdmFybyBIZXJyZXJhIDxhbHZoZXJy ZUBhbHZoLm5vLWlwLm9yZz4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yMDIzMDQw NzA3NTAwOS5pZ2c3YmUyN2hhMmh0a2J0QGF3b3JrMy5hbmFyYXplbC5kZQoKQnJhbmNoCi0tLS0t LQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9j b21taXRkaWZmLzI2NjY5NzU3YjZhNzY2NWMxMDY5ZTc3ZTY0NzJiZDg1NTAxOTNjYTYKCk1vZGlm aWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9tb25pdG9yaW5nLnNnbWwgICAg ICAgICAgICAgICAgIHwgMTEgKysrKysrKysrKysKc3JjL2JhY2tlbmQvYWNjZXNzL2dpc3QvZ2lz dHhsb2cuYyAgICAgICAgICAgfCAgMiArKwpzcmMvYmFja2VuZC9hY2Nlc3MvaGFzaC9oYXNoX3hs b2cuYyAgICAgICAgICB8ICAxICsKc3JjL2JhY2tlbmQvYWNjZXNzL2hlYXAvaGVhcGFtLmMgICAg ICAgICAgICAgfCAgMyArKysKc3JjL2JhY2tlbmQvYWNjZXNzL25idHJlZS9uYnR4bG9nLmMgICAg ICAgICAgfCAgMiArKwpzcmMvYmFja2VuZC9hY2Nlc3Mvc3BnaXN0L3NwZ3hsb2cuYyAgICAgICAg ICB8ICAxICsKc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0veGxvZy5jICAgICAgICAgICAgfCAx NSArKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvY2F0YWxvZy9zeXN0ZW1fdmlld3Muc3FsICAg ICAgICAgfCAgMyArKy0Kc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vc2xvdC5jICAgICAgICAgICAg ICAgfCAgOCArKysrKysrLQpzcmMvYmFja2VuZC9zdG9yYWdlL2lwYy9wcm9jc2lnbmFsLmMgICAg ICAgICB8ICAzICsrKwpzcmMvYmFja2VuZC9zdG9yYWdlL2lwYy9zdGFuZGJ5LmMgICAgICAgICAg ICB8IDIwICsrKysrKysrKysrKysrKysrKystCnNyYy9iYWNrZW5kL3Rjb3AvcG9zdGdyZXMuYyAg ICAgICAgICAgICAgICAgIHwgIDkgKysrKysrKysrCnNyYy9iYWNrZW5kL3V0aWxzL2FjdGl2aXR5 L3Bnc3RhdF9kYXRhYmFzZS5jIHwgIDQgKysrKwpzcmMvYmFja2VuZC91dGlscy9hZHQvcGdzdGF0 ZnVuY3MuYyAgICAgICAgICB8ICAzICsrKwpzcmMvaW5jbHVkZS9jYXRhbG9nL2NhdHZlcnNpb24u aCAgICAgICAgICAgICB8ICAyICstCnNyYy9pbmNsdWRlL2NhdGFsb2cvcGdfcHJvYy5kYXQgICAg ICAgICAgICAgIHwgIDUgKysrKysKc3JjL2luY2x1ZGUvcGdzdGF0LmggICAgICAgICAgICAgICAg ICAgICAgICAgfCAgMyArKy0Kc3JjL2luY2x1ZGUvc3RvcmFnZS9wcm9jc2lnbmFsLmggICAgICAg ICAgICAgfCAgMSArCnNyYy9pbmNsdWRlL3N0b3JhZ2Uvc3RhbmRieS5oICAgICAgICAgICAgICAg IHwgIDIgKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ydWxlcy5vdXQgICAgICAgICAgfCAg MyArKy0KMjAgZmlsZXMgY2hhbmdlZCwgOTUgaW5zZXJ0aW9ucygrKSwgNiBkZWxldGlvbnMoLSkK Cg== --===============8795724329938134553==--