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 1qsRJc-00846C-2Z for pgsql-committers@arkaria.postgresql.org; Mon, 16 Oct 2023 17:23:40 +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 1qsRJZ-002wDm-LE for pgsql-committers@arkaria.postgresql.org; Mon, 16 Oct 2023 17:23:38 +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 1qsRHN-002u5v-3p for pgsql-committers@lists.postgresql.org; Mon, 16 Oct 2023 17:21:21 +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 1qsRHI-000mj1-W5 for pgsql-committers@lists.postgresql.org; Mon, 16 Oct 2023 17:21:20 +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=/odI/a2FnyByRSJeqcdn3tpDOGEwVl9zJo7TgkoN9v8=; b=6SCxBfd4PbCZ5a8iO/L7KGwKyy LHJxillMcvYsqnJEruD2PQiuz/tp2kwYLNxXVciGb1VNcncrvRz42aGxxPkKcRHj0lw66M52Iy27Y 2KvXQC4ayhGDp+JezBg7GiEew2RA4Ng08+se55KQo3+OMMiPVlFhx+UQRqQO66oN6Rtq90CGCDVIR I7TQfXb1kzdvO7AUv4TndaMLFQ74ubP7kz99z+D/eQ5X28Im4RSpsvdFEEyOMwMYVOeFzsfpYE5uL W+IoGlyUaSIfyGNWu8NFZrUHdJHRivdNJ0JXXZd+8UBWd7QRJC2t3DJ0k8thFE6N6tphiGiTRkGkp Z1VKvaDg==; 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-0002Ka-DQ 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-000sDw-7K for pgsql-committers@lists.postgresql.org; Mon, 16 Oct 2023 17:21:15 +0000 Content-Type: multipart/mixed; boundary="===============2366677713566189615==" 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 --===============2366677713566189615== 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 YW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNx bC5vcmcvcGcvY29tbWl0ZGlmZi9hNzBiY2U0M2ZiY2VhYjZiZjBiNDk0OThhMDY0YzRlODdjZGJm NzJmCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3NnbWwvbWFpbnRlbmFu Y2Uuc2dtbCB8IDExMiArKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKystLS0tLS0K MSBmaWxlIGNoYW5nZWQsIDk3IGluc2VydGlvbnMoKyksIDE1IGRlbGV0aW9ucygtKQoK --===============2366677713566189615==--