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 1swY79-004SVU-Cn for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Oct 2024 02:32:20 +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 1swY78-008PSl-D7 for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Oct 2024 02:32:18 +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 1swY78-008PSc-1q for pgsql-hackers@lists.postgresql.org; Fri, 04 Oct 2024 02:32:18 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1swY72-002RMR-Jz for pgsql-hackers@postgresql.org; Fri, 04 Oct 2024 02:32:16 +0000 Received: from oss.nttdata.com (localhost [127.0.0.1]) by oss.nttdata.com (Postfix) with ESMTPA id 7BEA560778 for ; Fri, 4 Oct 2024 11:32:08 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.11 at oss.nttdata.com MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_efe63af95925900840c932307f84a21b" Content-Transfer-Encoding: 7bit Date: Fri, 04 Oct 2024 11:32:08 +0900 From: btogiwarayuushi To: pgsql-hackers@postgresql.org Subject: Function for listing pg_wal/summaries directory User-Agent: Roundcube Webmail/1.4.11 Message-ID: X-Sender: btogiwarayuushi@oss.nttdata.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=_efe63af95925900840c932307f84a21b Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Hi, While WAL summaries feature and some support functions have been added in version 17, merely listing the contents of the pg_wal/summaries directory is missing. As discussed in the pg_ls_archive_status() discussion, it would be convenient to add pg_ls_summariesdir() that lists the contents of the pg_wal/summaries directory with the pg_monitor role. This patch is based on a very recent master and does not include the catversion bump. Best, Yushi --=_efe63af95925900840c932307f84a21b Content-Transfer-Encoding: base64 Content-Type: text/x-diff; name=ls_summariesdir.diff Content-Disposition: attachment; filename=ls_summariesdir.diff; size=5008 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9mdW5jLnNnbWwgYi9kb2Mvc3JjL3NnbWwvZnVuYy5z Z21sCmluZGV4IGQ2YWNkZDMwNTkuLjFiN2Y1YzNhMTIgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dt bC9mdW5jLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL2Z1bmMuc2dtbApAQCAtMzA1MzAsNiArMzA1 MzAsMzAgQEAgU0VMRUNUIHBnX3NpemVfcHJldHR5KHN1bShwZ19yZWxhdGlvbl9zaXplKHJlbGlk KSkpIEFTIHRvdGFsX3NpemUKICAgICAgICA8L3BhcmE+PC9lbnRyeT4KICAgICAgIDwvcm93Pgog CisgICAgICA8cm93PgorICAgICAgIDxlbnRyeSByb2xlPSJmdW5jX3RhYmxlX2VudHJ5Ij48cGFy YSByb2xlPSJmdW5jX3NpZ25hdHVyZSI+CisgICAgICAgIDxpbmRleHRlcm0+CisgICAgICAgICA8 cHJpbWFyeT5wZ19sc19zdW1tYXJpZXNkaXI8L3ByaW1hcnk+CisgICAgICAgIDwvaW5kZXh0ZXJt PgorICAgICAgICA8ZnVuY3Rpb24+cGdfbHNfc3VtbWFyaWVzZGlyPC9mdW5jdGlvbj4gKCkKKyAg ICAgICAgPHJldHVybnZhbHVlPnNldG9mIHJlY29yZDwvcmV0dXJudmFsdWU+CisgICAgICAgICgg PHBhcmFtZXRlcj5uYW1lPC9wYXJhbWV0ZXI+IDx0eXBlPnRleHQ8L3R5cGU+LAorICAgICAgICA8 cGFyYW1ldGVyPnNpemU8L3BhcmFtZXRlcj4gPHR5cGU+YmlnaW50PC90eXBlPiwKKyAgICAgICAg PHBhcmFtZXRlcj5tb2RpZmljYXRpb248L3BhcmFtZXRlcj4gPHR5cGU+dGltZXN0YW1wIHdpdGgg dGltZSB6b25lPC90eXBlPiApCisgICAgICAgPC9wYXJhPgorICAgICAgIDxwYXJhPgorICAgICAg ICBSZXR1cm5zIHRoZSBuYW1lLCBzaXplLCBhbmQgbGFzdCBtb2RpZmljYXRpb24gdGltZSAobXRp bWUpIG9mIGVhY2gKKyAgICAgICAgb3JkaW5hcnkgZmlsZSBpbiB0aGUgc2VydmVyJ3MgV0FMIHN1 bW1hcnkgZGlyZWN0b3J5CisgICAgICAgICg8ZmlsZW5hbWU+cGdfd2FsL3N1bW1hcmllczwvZmls ZW5hbWU+KS4gIEZpbGVuYW1lcyBiZWdpbm5pbmcKKyAgICAgICAgd2l0aCBhIGRvdCwgZGlyZWN0 b3JpZXMsIGFuZCBvdGhlciBzcGVjaWFsIGZpbGVzIGFyZSBleGNsdWRlZC4KKyAgICAgICA8L3Bh cmE+CisgICAgICAgPHBhcmE+CisgICAgICAgIFRoaXMgZnVuY3Rpb24gaXMgcmVzdHJpY3RlZCB0 byBzdXBlcnVzZXJzIGFuZCBtZW1iZXJzIG9mCisgICAgICAgIHRoZSA8bGl0ZXJhbD5wZ19tb25p dG9yPC9saXRlcmFsPiByb2xlIGJ5IGRlZmF1bHQsIGJ1dCBvdGhlciB1c2VycyBjYW4KKyAgICAg ICAgYmUgZ3JhbnRlZCBFWEVDVVRFIHRvIHJ1biB0aGUgZnVuY3Rpb24uCisgICAgICAgPC9wYXJh PjwvZW50cnk+CisgICAgICA8L3Jvdz4KKwogICAgICAgPHJvdz4KICAgICAgICA8ZW50cnkgcm9s ZT0iZnVuY190YWJsZV9lbnRyeSI+PHBhcmEgcm9sZT0iZnVuY19zaWduYXR1cmUiPgogICAgICAg ICA8aW5kZXh0ZXJtPgpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvY2F0YWxvZy9zeXN0ZW1fZnVu Y3Rpb25zLnNxbCBiL3NyYy9iYWNrZW5kL2NhdGFsb2cvc3lzdGVtX2Z1bmN0aW9ucy5zcWwKaW5k ZXggYjBkMGRlMDUxZS4uZmQ2YjYwNmFlOSAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvY2F0YWxv Zy9zeXN0ZW1fZnVuY3Rpb25zLnNxbAorKysgYi9zcmMvYmFja2VuZC9jYXRhbG9nL3N5c3RlbV9m dW5jdGlvbnMuc3FsCkBAIC03MDAsNiArNzAwLDggQEAgUkVWT0tFIEVYRUNVVEUgT04gRlVOQ1RJ T04gcGdfbHNfd2FsZGlyKCkgRlJPTSBwdWJsaWM7CiAKIFJFVk9LRSBFWEVDVVRFIE9OIEZVTkNU SU9OIHBnX2xzX2FyY2hpdmVfc3RhdHVzZGlyKCkgRlJPTSBwdWJsaWM7CiAKK1JFVk9LRSBFWEVD VVRFIE9OIEZVTkNUSU9OIHBnX2xzX3N1bW1hcmllc2RpcigpIEZST00gcHVibGljOworCiBSRVZP S0UgRVhFQ1VURSBPTiBGVU5DVElPTiBwZ19sc190bXBkaXIoKSBGUk9NIHB1YmxpYzsKIAogUkVW T0tFIEVYRUNVVEUgT04gRlVOQ1RJT04gcGdfbHNfdG1wZGlyKG9pZCkgRlJPTSBwdWJsaWM7CkBA IC03NzAsNiArNzcyLDggQEAgR1JBTlQgRVhFQ1VURSBPTiBGVU5DVElPTiBwZ19sc193YWxkaXIo KSBUTyBwZ19tb25pdG9yOwogCiBHUkFOVCBFWEVDVVRFIE9OIEZVTkNUSU9OIHBnX2xzX2FyY2hp dmVfc3RhdHVzZGlyKCkgVE8gcGdfbW9uaXRvcjsKIAorR1JBTlQgRVhFQ1VURSBPTiBGVU5DVElP TiBwZ19sc19zdW1tYXJpZXNkaXIoKSBUTyBwZ19tb25pdG9yOworCiBHUkFOVCBFWEVDVVRFIE9O IEZVTkNUSU9OIHBnX2xzX3RtcGRpcigpIFRPIHBnX21vbml0b3I7CiAKIEdSQU5UIEVYRUNVVEUg T04gRlVOQ1RJT04gcGdfbHNfdG1wZGlyKG9pZCkgVE8gcGdfbW9uaXRvcjsKZGlmZiAtLWdpdCBh L3NyYy9iYWNrZW5kL3V0aWxzL2FkdC9nZW5maWxlLmMgYi9zcmMvYmFja2VuZC91dGlscy9hZHQv Z2VuZmlsZS5jCmluZGV4IDI0Yjk1YzMyYjcuLmQ4NGVkODk3MGUgMTAwNjQ0Ci0tLSBhL3NyYy9i YWNrZW5kL3V0aWxzL2FkdC9nZW5maWxlLmMKKysrIGIvc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2dl bmZpbGUuYwpAQCAtNjg5LDYgKzY4OSwxNSBAQCBwZ19sc19hcmNoaXZlX3N0YXR1c2RpcihQR19G VU5DVElPTl9BUkdTKQogCXJldHVybiBwZ19sc19kaXJfZmlsZXMoZmNpbmZvLCBYTE9HRElSICIv YXJjaGl2ZV9zdGF0dXMiLCB0cnVlKTsKIH0KIAorLyoKKyAqIEZ1bmN0aW9uIHRvIHJldHVybiB0 aGUgbGlzdCBvZiBmaWxlcyBpbiB0aGUgV0FMIHN1bW1hcnkgZGlyZWN0b3J5LgorICovCitEYXR1 bQorcGdfbHNfc3VtbWFyaWVzZGlyKFBHX0ZVTkNUSU9OX0FSR1MpCit7CisJcmV0dXJuIHBnX2xz X2Rpcl9maWxlcyhmY2luZm8sIFhMT0dESVIgIi9zdW1tYXJpZXMiLCB0cnVlKTsKK30KKwogLyoK ICAqIEZ1bmN0aW9uIHRvIHJldHVybiB0aGUgbGlzdCBvZiBmaWxlcyBpbiB0aGUgUEdfTE9HSUNB TF9TTkFQU0hPVFNfRElSCiAgKiBkaXJlY3RvcnkuCmRpZmYgLS1naXQgYS9zcmMvaW5jbHVkZS9j YXRhbG9nL3BnX3Byb2MuZGF0IGIvc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19wcm9jLmRhdAppbmRl eCA3N2Y1NGE3OWU2Li5hMzAzNTU1OWI2IDEwMDY0NAotLS0gYS9zcmMvaW5jbHVkZS9jYXRhbG9n L3BnX3Byb2MuZGF0CisrKyBiL3NyYy9pbmNsdWRlL2NhdGFsb2cvcGdfcHJvYy5kYXQKQEAgLTEy MTczLDYgKzEyMTczLDEyIEBACiAgIHByb3ZvbGF0aWxlID0+ICd2JywgcHJvcmV0dHlwZSA9PiAn cmVjb3JkJywgcHJvYXJndHlwZXMgPT4gJycsCiAgIHByb2FsbGFyZ3R5cGVzID0+ICd7dGV4dCxp bnQ4LHRpbWVzdGFtcHR6fScsIHByb2FyZ21vZGVzID0+ICd7byxvLG99JywKICAgcHJvYXJnbmFt ZXMgPT4gJ3tuYW1lLHNpemUsbW9kaWZpY2F0aW9ufScsIHByb3NyYyA9PiAncGdfbHNfd2FsZGly JyB9LAoreyBvaWQgPT4gJzUxMDEnLCBkZXNjciA9PiAnbGlzdCBvZiBmaWxlcyBpbiB0aGUgc3Vt bWFyaWVzIGRpcmVjdG9yeScsCisgIHByb25hbWUgPT4gJ3BnX2xzX3N1bW1hcmllc2RpcicsIHBy b2Nvc3QgPT4gJzEwJywgcHJvcm93cyA9PiAnMjAnLAorICBwcm9yZXRzZXQgPT4gJ3QnLCBwcm92 b2xhdGlsZSA9PiAndicsIHByb3JldHR5cGUgPT4gJ3JlY29yZCcsCisgIHByb2FyZ3R5cGVzID0+ ICcnLCBwcm9hbGxhcmd0eXBlcyA9PiAne3RleHQsaW50OCx0aW1lc3RhbXB0en0nLAorICBwcm9h cmdtb2RlcyA9PiAne28sbyxvfScsIHByb2FyZ25hbWVzID0+ICd7bmFtZSxzaXplLG1vZGlmaWNh dGlvbn0nLAorICBwcm9zcmMgPT4gJ3BnX2xzX3N1bW1hcmllc2RpcicgfSwKIHsgb2lkID0+ICc1 MDMxJywgZGVzY3IgPT4gJ2xpc3Qgb2YgZmlsZXMgaW4gdGhlIGFyY2hpdmVfc3RhdHVzIGRpcmVj dG9yeScsCiAgIHByb25hbWUgPT4gJ3BnX2xzX2FyY2hpdmVfc3RhdHVzZGlyJywgcHJvY29zdCA9 PiAnMTAnLCBwcm9yb3dzID0+ICcyMCcsCiAgIHByb3JldHNldCA9PiAndCcsIHByb3ZvbGF0aWxl ID0+ICd2JywgcHJvcmV0dHlwZSA9PiAncmVjb3JkJywKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvbWlzY19mdW5jdGlvbnMub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9taXNjX2Z1bmN0aW9ucy5vdXQKaW5kZXggNWY3YmY2YjhhZi4uMzZiMTIwMWY5ZiAxMDA2 NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9taXNjX2Z1bmN0aW9ucy5vdXQKKysr IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9taXNjX2Z1bmN0aW9ucy5vdXQKQEAgLTQxMiw2 ICs0MTIsMTIgQEAgc2VsZWN0IGNvdW50KCopID49IDAgYXMgb2sgZnJvbSBwZ19sc19hcmNoaXZl X3N0YXR1c2RpcigpOwogIHQKICgxIHJvdykKIAorc2VsZWN0IGNvdW50KCopID49IDAgYXMgb2sg ZnJvbSBwZ19sc19zdW1tYXJpZXNkaXIoKTsKKyBvayAKKy0tLS0KKyB0CisoMSByb3cpCisKIC0t IHBnX3JlYWRfZmlsZSgpCiBzZWxlY3QgbGVuZ3RoKHBnX3JlYWRfZmlsZSgncG9zdG1hc3Rlci5w aWQnKSkgPiAyMDsKICA/Y29sdW1uPyAKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L21pc2NfZnVuY3Rpb25zLnNxbCBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL21pc2NfZnVuY3Rpb25z LnNxbAppbmRleCAxZTkwZDYwYWYzLi5iNzQ5NWQ3MGViIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9y ZWdyZXNzL3NxbC9taXNjX2Z1bmN0aW9ucy5zcWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwv bWlzY19mdW5jdGlvbnMuc3FsCkBAIC0xNjMsNiArMTYzLDcgQEAgc2VsZWN0ICh3KS5zaXplID0g OnNlZ3NpemUgYXMgb2sKIGZyb20gKHNlbGVjdCBwZ19sc193YWxkaXIoKSB3KSBzcyB3aGVyZSBs ZW5ndGgoKHcpLm5hbWUpID0gMjQgbGltaXQgMTsKIAogc2VsZWN0IGNvdW50KCopID49IDAgYXMg b2sgZnJvbSBwZ19sc19hcmNoaXZlX3N0YXR1c2RpcigpOworc2VsZWN0IGNvdW50KCopID49IDAg YXMgb2sgZnJvbSBwZ19sc19zdW1tYXJpZXNkaXIoKTsKIAogLS0gcGdfcmVhZF9maWxlKCkKIHNl bGVjdCBsZW5ndGgocGdfcmVhZF9maWxlKCdwb3N0bWFzdGVyLnBpZCcpKSA+IDIwOw== --=_efe63af95925900840c932307f84a21b--