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 1t1UFY-00GX1u-R9 for pgsql-docs@arkaria.postgresql.org; Thu, 17 Oct 2024 17:25:24 +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 1t1UFW-007ae7-2i for pgsql-docs@arkaria.postgresql.org; Thu, 17 Oct 2024 17:25:22 +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 1t1UFV-007adz-Pk for pgsql-docs@lists.postgresql.org; Thu, 17 Oct 2024 17:25:22 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t1UFT-001P2N-FV for pgsql-docs@lists.postgresql.org; Thu, 17 Oct 2024 17:25:20 +0000 Received: from [192.168.11.3] (p4010149-ipxg13601funabasi.chiba.ocn.ne.jp [153.165.135.149]) by oss.nttdata.com (Postfix) with ESMTPSA id A4DF26067A for ; Fri, 18 Oct 2024 02:25:16 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.11 at oss.nttdata.com Content-Type: multipart/mixed; boundary="------------4zQnoP0XzY6RUpNXcEZ56SNP" Message-ID: Date: Fri, 18 Oct 2024 02:25:15 +0900 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: en-US To: pgsql-docs@lists.postgresql.org From: Fujii Masao Subject: Clarify old WAL files cannot be removed until they are summarized List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------4zQnoP0XzY6RUpNXcEZ56SNP Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hi, The documentation in wal.sgml explains that old WAL files cannot be removed or recycled until they are archived (when WAL archiving is used) or replicated (when using replication slots). However, it did not mention that, similarly, old WAL files are also kept until they are summarized if WAL summarization is enabled. Attached patch adds that clarification to the documentation. Thought? Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION --------------4zQnoP0XzY6RUpNXcEZ56SNP Content-Type: text/plain; charset=UTF-8; name="v1-0001-doc-Clarify-old-WAL-files-are-kept-until-they-are.patch" Content-Disposition: attachment; filename*0="v1-0001-doc-Clarify-old-WAL-files-are-kept-until-they-are.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSAxMzM5YmJiNDA5NmRmMDE4MjkxM2MxOWE2Mjc3YTEwNWEyZjViZWU4IE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5v cmc+CkRhdGU6IEZyaSwgMTggT2N0IDIwMjQgMDI6MjA6NDkgKzA5MDAKU3ViamVjdDogW1BB VENIIHYxXSBkb2M6IENsYXJpZnkgb2xkIFdBTCBmaWxlcyBhcmUga2VwdCB1bnRpbCB0aGV5 IGFyZQogc3VtbWFyaXplZC4KClRoZSBkb2N1bWVudGF0aW9uIGluIHdhbC5zZ21sIGV4cGxh aW5zIHRoYXQgb2xkIFdBTCBmaWxlcyBjYW5ub3QgYmUKcmVtb3ZlZCBvciByZWN5Y2xlZCB1 bnRpbCB0aGV5IGFyZSBhcmNoaXZlZCAod2hlbiBXQUwgYXJjaGl2aW5nIGlzIHVzZWQpCm9y IHJlcGxpY2F0ZWQgKHdoZW4gdXNpbmcgcmVwbGljYXRpb24gc2xvdHMpLiBIb3dldmVyLCBp dCBkaWQgbm90IG1lbnRpb24KdGhhdCwgc2ltaWxhcmx5LCBvbGQgV0FMIGZpbGVzIGFyZSBh bHNvIGtlcHQgdW50aWwgdGhleSBhcmUgc3VtbWFyaXplZAppZiBXQUwgc3VtbWFyaXphdGlv biBpcyBlbmFibGVkLiBUaGlzIGNvbW1pdCBhZGRzIHRoYXQgY2xhcmlmaWNhdGlvbgp0byB0 aGUgZG9jdW1lbnRhdGlvbi4KLS0tCiBkb2Mvc3JjL3NnbWwvd2FsLnNnbWwgfCAyICsrCiAx IGZpbGUgY2hhbmdlZCwgMiBpbnNlcnRpb25zKCspCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9z Z21sL3dhbC5zZ21sIGIvZG9jL3NyYy9zZ21sL3dhbC5zZ21sCmluZGV4IGEzNGNkZGI1ZWQu LjU1ODhmMzFjNTUgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC93YWwuc2dtbAorKysgYi9k b2Mvc3JjL3NnbWwvd2FsLnNnbWwKQEAgLTY0Myw2ICs2NDMsOCBAQAogICAgdW50aWwgdGhl IHNpdHVhdGlvbiBpcyByZXNvbHZlZC4gQSBzbG93IG9yIGZhaWxlZCBzdGFuZGJ5IHNlcnZl ciB0aGF0CiAgICB1c2VzIGEgcmVwbGljYXRpb24gc2xvdCB3aWxsIGhhdmUgdGhlIHNhbWUg ZWZmZWN0IChzZWUKICAgIDx4cmVmIGxpbmtlbmQ9InN0cmVhbWluZy1yZXBsaWNhdGlvbi1z bG90cyIvPikuCisgICBTaW1pbGFybHksIGlmIFdBTCBzdW1tYXJpemF0aW9uIGlzIGVuYWJs ZWQsIG9sZCBzZWdtZW50cyBhcmUga2VwdAorICAgdW50aWwgdGhleSBhcmUgc3VtbWFyaXpl ZC4KICAgPC9wYXJhPgogCiAgIDxwYXJhPgotLSAKMi40Ni4yCgo= --------------4zQnoP0XzY6RUpNXcEZ56SNP--