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 1qsRHO-0083w5-2n for pgsql-committers@arkaria.postgresql.org; Mon, 16 Oct 2023 17:21:22 +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 1qsRHM-002u4R-3W for pgsql-committers@arkaria.postgresql.org; Mon, 16 Oct 2023 17:21:20 +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 1qsRHL-002u4J-Rp for pgsql-committers@lists.postgresql.org; Mon, 16 Oct 2023 17:21:20 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qsRHJ-000mj0-0p for pgsql-committers@lists.postgresql.org; Mon, 16 Oct 2023 17:21:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=eP9532lxBt6B3gTfkPfZKOizkvQYUycK+sFrcGF9AAg=; b=1vhaD71AssJao/FHONuuQvWYYq WoeAI8/LbaEyXs3ybkz/GMHcsAzHz7GfY442gMZyXTtF6Uwuxic0II7sSNo/qiq1bAuDaTa/18NTN J2fAQqvQUAW7ePhPtKqMMZzFTrVvGKOBkSmaJ1ObjmprlfiE46wWgsDovKOUSIdAYL8NOR+0xwMNh m9VYDoEm3d6AekLc6GPTg07hq82RDvQso4RPM2gLjIlCm0qg4Y59jh6P4Ze9Ip/SWpqWC/OvRysr5 oeavkk+/d9TC3YrnYs4qqtd/Cf03dOt9LEi7mCU5nI/ku53udnGcngfqwQ0C/0Cihbs6FjkV4Xlx3 40S8aGWw==; 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 1qsRHI-0002KX-Ar for pgsql-committers@lists.postgresql.org; Mon, 16 Oct 2023 17:21:16 +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 1qsRHH-000sDx-7w for pgsql-committers@lists.postgresql.org; Mon, 16 Oct 2023 17:21:15 +0000 Content-Type: multipart/mixed; boundary="===============7096471174528111597==" MIME-Version: 1.0 From: Robert Haas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Update the documentation on recovering from (M)XID exhaustion. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 16 Oct 2023 17:21:15 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7096471174528111597== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VXBkYXRlIHRoZSBkb2N1bWVudGF0aW9uIG9uIHJlY292ZXJpbmcgZnJvbSAoTSlYSUQgZXhoYXVz dGlvbi4KClRoZSBvbGQgZG9jdW1lbnRhdGlvbiBlbmNvdXJhZ2VzIGVudGVyaW5nIHNpbmdsZS11 c2VyIG1vZGUgZm9yIG5vCnJlYXNvbiwgd2hpY2ggaXMgYSBiYWQgcGxhbiBpbiBtb3N0IGNhc2Vz LiBJbnN0ZWFkLCBkaXNjb3VyYWdlIHVzZXJzCmZyb20gZG9pbmcgdGhhdCwgYW5kIGV4cGxhaW4g dGhlIGxpbWl0ZWQgY2FzZXMgaW4gd2hpY2ggaXQgbWF5IGJlCmRlc2lyYWJsZS4KClRoZSBvbGQg ZG9jdW1lbnRhdGlvbiBjbGFpbXMgdGhhdCBydW5uaW5nIFZBQ1VVTSBhcyBhbnlvbmUgYnV0IHRo ZQpzdXBlcnVzZXIgY2FuJ3QgcG9zc2libHkgd29yaywgd2hpY2ggaXMgbm90IHJlYWxseSB0cnVl LCBiZWNhdXNlIGl0Cm1pZ2h0IGJlIHRoYXQgc29tZSBvdGhlciB1c2VyIGhhcyBlbm91Z2ggcGVy bWlzc2lvbnMgdG8gVkFDVVVNIGFsbAp0aGUgdGFibGVzIHRoYXQgbWF0dGVyLiBXZWFrZW4gdGhl IGxhbmd1YWdlIGp1c3QgYSBiaXQuCgpUaGUgb2xkIGRvY3VtZW50YXRpb24gY2xhaW1zIHRoYXQg eW91IGNhbid0IHJ1biBhbnkgY29tbWFuZHMKd2hlbiBuZWFyIFhJRCBleGhhdXN0aW9uLCB3aGlj aCBpcyBmYWxzZSBiZWNhdXNlIHlvdSBjYW4gc3RpbGwKcnVuIGNvbW1hbmRzIHRoYXQgZG9uJ3Qg cmVxdWlyZSBhbiBYSUQsIGxpa2UgYSBTRUxFQ1Qgd2l0aG91dCBhCmxvY2tpbmcgY2xhdXNlLgoK VGhlIG9sZCBkb2N1bWVudGF0aW9uIGRvZXNuJ3QgY2xlYXJseSBleHBsYWluIHRoYXQgaXQncyBh IGdvb2QgaWRlYQp0byBnZXQgcmlkIG9mIHByZXBhcmVkIHRyYW5zYWN0b25zLCBsb25nLXJ1bm5p bmcgdHJhbnNhY3Rpb25zLCBhbmQKcmVwbGljYXRpb24gc2xvdHMgdGhhdCBhcmUgcHJldmVudGlu ZyAoTSlYSUQgaG9yaXpvbiBhZHZhbmNlbWVudC4KU3BlbGwgb3V0IHRoZSBzdGVwcyB0byBkbyB0 aGF0LgoKQWxzbywgZGlzY291cmFnZSB0aGUgdXNlIG9mIFZBQ1VVTSBGVUxMIGFuZCBWQUNVVU0g RlJFRVpFIGluCnRoaXMgdHlwZSBvZiBzY2VuYXJpby4KCkJhY2stcGF0Y2ggdG8gdjE0LiBNdWNo IG9mIHRoaXMgaXMgZ29vZCBhZHZpY2Ugb24gYWxsIHN1cHBvcnRlZAp2ZXJzaW9ucywgYnV0IGJl Zm9yZSA2MGYxZjA5ZmY0NDMwODY2N2VmNmM3MmZiYWZkNjgyMzVlNTVhZTI3CnRoZSBjaGFuY2Vz IG9mIFZBQ1VVTSBmYWlsaW5nIGluIG11bHRpLXVzZXIgbW9kZSB3ZXJlIG11Y2ggaGlnaGVyLgoK QWxleGFuZGVyIEFsZWtzZWV2LCBKb2huIE5heWxvciwgUm9iZXJ0IEhhYXMsIHJldmlld2VkIGF0 IHZhcmlvdXMKdGltZXMgYnkgUGV0ZXIgR2VvZ2hlZ2FuLCBIYW5udSBLcm9zaW5nLCBhbmQgQW5k cmVzIEZyZXVuZC4KCkRpc2N1c3Npb246IGh0dHA6Ly9wb3N0Z3IuZXMvbS9DQStUZ21vWXRzVURy emFIY21qRmhMelRrMVZFdjI5bU9fdS1NVCtYV0hyQkpfNG5EOEFAbWFpbC5nbWFpbC5jb20KCkJy YW5jaAotLS0tLS0KUkVMXzE2X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBv c3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvMDhjMTc5NWM1MmI4NTA0ZTJmNWMxNDg0NTRkYjg0 ZjczYWEwMmU0MAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9jL3NyYy9zZ21sL21h aW50ZW5hbmNlLnNnbWwgfCAxMTIgKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysr LS0tLS0tCjEgZmlsZSBjaGFuZ2VkLCA5NyBpbnNlcnRpb25zKCspLCAxNSBkZWxldGlvbnMoLSkK Cg== --===============7096471174528111597==--