pg_archivecleanup - add the ability to detect, archive and delete the unneeded wal files on the primary

1 patchset tracked - current t45276_5

v5t45276_5posted Apr 18, 2022successappliesrecent 0dpg 20

base9e17d25e7 about 23 hours ago on master

applyapplied about 22 hours ago

rebaselast tried about 22 hours ago on 9e17d25e7

pushabout 22 hours ago -> d0ca9b0a3 branch diff vs base

Result	Att	PG	Tests	Build / test	Image	When
success	1	20	1037 / 1037	2m 11s / 4m 36s	`docker run ... :t45276`	about 22 hours ago
run 35492407265 executed 1037 - ccache 98 hit / 6525 miss - head d0ca9b0a3 - digest sha256:5213eea9844758... - run 35492407265
success	1	20	1037 / 1037	2m 56s / 5m 24s	`docker run ... @sha256:1de3566...`	2 days ago
run 35424619255 executed 1037 - ccache 98 hit / 6525 miss - head a60cea80f - digest sha256:1de3566c77165e... - run 35424619255
success	1	20	1037 / 1037	2m 54s / 5m 23s	`docker run ... @sha256:6fc3ccb...`	3 days ago
run 35311658091 executed 1037 - ccache 98 hit / 6525 miss - head 9d1e1d29c - digest sha256:6fc3ccbfd4ee2e... - run 35311658091
success	1	20	1037 / 1037	2m 53s / 5m 13s	`docker run ... @sha256:9c222a6...`	4 days ago
run 35186457869 executed 1037 - ccache 98 hit / 6525 miss - head 7b404e4e4 - digest sha256:9c222a61ccea25... - run 35186457869
success	1	20	1037 / 1037	2m 44s / 4m 42s	`docker run ... @sha256:6362848...`	5 days ago
run 35060121173 executed 1037 - ccache 98 hit / 6525 miss - head ebe60f52c - digest sha256:63628481f3c08d... - run 35060121173
success	1	20	1037 / 1037	2m 54s / 5m 19s	`docker run ... @sha256:9f6c9e8...`	6 days ago
run 34933294677 executed 1037 - ccache 98 hit / 6524 miss - head 297d12893 - digest sha256:9f6c9e8e8c3ab1... - run 34933294677
success	1	20	1024 / 1024	2m 57s / 5m 32s	`docker run ... @sha256:9c42882...`	7 days ago
run 34810084423 executed 1024 - ccache 98 hit / 6524 miss - head eb054a332 - digest sha256:9c42882a074aea... - run 34810084423
success	1	20	1024 / 1024	1m 50s / 4m 12s	`docker run ... @sha256:0c6a4f8...`	Sep 13, 05:21
run 34739737028 executed 1024 - ccache 98 hit / 6524 miss - head 0873ce5ad - digest sha256:0c6a4f82a14fea... - run 34739737028
success	1	20	1024 / 1024	2m 09s / 4m 27s	`docker run ... @sha256:f104ffe...`	Sep 12, 05:09
run 34674375120 executed 1024 - ccache 98 hit / 6524 miss - head 38e219344 - digest sha256:f104ffe94eed89... - run 34674375120
success	1	20	1023 / 1023	2m 56s / 5m 37s	`docker run ... @sha256:1e254f4...`	Sep 11, 05:08
run 34564069600 executed 1023 - ccache 98 hit / 6524 miss - head 48f6f1fab - digest sha256:1e254f4a6879cb... - run 34564069600
success	1	20	1023 / 1023	2m 09s / 3m 55s	`docker run ... @sha256:8929170...`	Sep 10, 05:07
run 34438960786 executed 1023 - ccache 98 hit / 6524 miss - head 041ff3703 - digest sha256:89291705897fb5... - run 34438960786
success	1	20	1021 / 1021	2m 46s / 4m 47s	`docker run ... @sha256:a846db2...`	Sep 09, 05:03
run 34312682680 executed 1021 - ccache 98 hit / 6524 miss - head dac628294 - digest sha256:a846db22dd5d94... - run 34312682680
success	1	20	1021 / 1021	1m 50s / 3m 47s	`docker run ... @sha256:31a747b...`	Sep 08, 04:57
run 34188212681 executed 1021 - ccache 98 hit / 6524 miss - head 0e4a0288e - digest sha256:31a747b110d695... - run 34188212681
success	1	20	1025 / 1025	2m 11s / 4m 44s	`docker run ... @sha256:3581583...`	Sep 07, 04:57
run 34084327982 executed 1025 - ccache 98 hit / 6528 miss - head 079a8d8d8 - digest sha256:3581583a752932... - run 34084327982
success	1	20	1025 / 1025	1m 44s / 4m 14s	`docker run ... @sha256:51cac6c...`	Sep 05, 06:44
run 33950171496 executed 1025 - ccache 98 hit / 6528 miss - head 4d5907d72 - digest sha256:51cac6c5ac6634... - run 33950171496
success	1	20	1025 / 1025	3m 01s / 5m 37s	`docker run ... @sha256:16c6ace...`	Sep 04, 06:45
run 33844838889 executed 1025 - ccache 98 hit / 6528 miss - head cf34c10bd - digest sha256:16c6ace08d5ccb... - run 33844838889
success	1	20	1024 / 1024	2m 55s / 5m 16s	`docker run ... @sha256:33007a9...`	Sep 03, 06:43
run 33723636761 executed 1024 - ccache 98 hit / 6527 miss - head b4dc912f0 - digest sha256:33007a9ee08144... - run 33723636761
success	1	20	1023 / 1023	2m 47s / 5m 21s	`docker run ... @sha256:a1960b6...`	Sep 02, 06:40
run 33598946054 executed 1023 - ccache 98 hit / 6527 miss - head 27462c3b7 - digest sha256:a1960b6bc9ec3b... - run 33598946054
success	1	20	1023 / 1023	2m 16s / 4m 07s	`docker run ... @sha256:94c5041...`	Sep 01, 06:37
run 33477646389 executed 1023 - ccache 98 hit / 6527 miss - head 02e9996f6 - digest sha256:94c5041b5fa29b... - run 33477646389
success	1	20	1023 / 1023	2m 50s / 5m 22s	`docker run ... @sha256:b82a51a...`	Aug 31, 06:19
run 33362623855 executed 1023 - ccache 98 hit / 6527 miss - head eb8ecdeae - digest sha256:b82a51a3ce63d9... - run 33362623855
success	1	20	1022 / 1022	2m 55s / 5m 14s	`docker run ... @sha256:03e7b86...`	Aug 30, 06:04
run 33295662300 executed 1022 - ccache 98 hit / 6526 miss - head 353b7b0ff - digest sha256:03e7b8691d2ad9... - run 33295662300
success	1	20	1022 / 1022	1m 49s / 4m 13s	`docker run ... @sha256:8261d67...`	Aug 29, 06:02
run 33237145084 executed 1022 - ccache 98 hit / 6526 miss - head 4957d6d8d - digest sha256:8261d67b9c367d... - run 33237145084
success	1	20	1022 / 1022	2m 09s / 4m 20s	`docker run ... @sha256:d5d4304...`	Aug 28, 05:54
run 33145753423 executed 1022 - ccache 98 hit / 6526 miss - head 68f8d5f68 - digest sha256:d5d43045772207... - run 33145753423
success	1	20	1022 / 1022	2m 48s / 4m 55s	`docker run ... @sha256:17f3017...`	Aug 27, 05:52
run 33043361439 executed 1022 - ccache 98 hit / 6526 miss - head 036ba229f - digest sha256:17f30177eb5474... - run 33043361439
success	1	20	1025 / 1025	2m 55s / 5m 28s	`docker run ... @sha256:5dc1e03...`	Aug 26, 05:27
run 32933384079 executed 1025 - ccache 98 hit / 6526 miss - head 9b6d85d95 - digest sha256:5dc1e0349e2c92... - run 32933384079
success	1	20	1025 / 1025	2m 48s / 5m 28s	`docker run ... @sha256:c5cf09e...`	Aug 25, 05:23
run 32811767096 executed 1025 - ccache 98 hit / 6526 miss - head 742b4d165 - digest sha256:c5cf09ebd40c6e... - run 32811767096
success	1	20	1024 / 1024	2m 56s / 5m 40s	`docker run ... @sha256:0f842c9...`	Aug 24, 05:22
run 32692507415 executed 1024 - ccache 98 hit / 6526 miss - head 9015603c3 - digest sha256:0f842c99633d9b... - run 32692507415
success	1	20	1024 / 1024	2m 57s / 5m 13s	`docker run ... @sha256:40c1a8e...`	Aug 23, 05:22
run 32619589032 executed 1024 - ccache 98 hit / 6526 miss - head dc7f54a17 - digest sha256:40c1a8e3ba6c00... - run 32619589032
success	1	20	1024 / 1024	2m 48s / 5m 11s	`docker run ... @sha256:be4de67...`	Aug 22, 05:19
run 32553480988 executed 1024 - ccache 98 hit / 6526 miss - head 8410cd188 - digest sha256:be4de6741ff7cc... - run 32553480988
success	1	20	1024 / 1024	2m 56s / 5m 31s	`docker run ... @sha256:e4e5a9b...`	Aug 21, 05:19
run 32449234195 executed 1024 - ccache 98 hit / 6526 miss - head 1d2cdd043 - digest sha256:e4e5a9bdf0ad32... - run 32449234195
success	1	20	1024 / 1024	2m 49s / 4m 49s	`docker run ... @sha256:3c79ae2...`	Aug 20, 05:15
run 32334042755 executed 1024 - ccache 98 hit / 6526 miss - head 9442868e8 - digest sha256:3c79ae2f7235dd... - run 32334042755
success	1	20	1024 / 1024	2m 59s / 5m 12s	`docker run ... @sha256:da458e8...`	Aug 19, 05:16
run 32217875657 executed 1024 - ccache 98 hit / 6526 miss - head 80ae93860 - digest sha256:da458e8d355381... - run 32217875657
success	1	20	1021 / 1021	2m 19s / 4m 31s	`docker run ... @sha256:3d3b8e8...`	Aug 18, 05:13
run 32100997774 executed 1021 - ccache 98 hit / 6525 miss - head b3c387b53 - digest sha256:3d3b8e822a93d4... - run 32100997774
success	1	20	1020 / 1020	2m 38s / 4m 29s	`docker run ... @sha256:136e42f...`	Aug 17, 05:13
run 31996068713 executed 1020 - ccache 98 hit / 6525 miss - head be43c46cc - digest sha256:136e42fbddc7d2... - run 31996068713
success	1	20	1020 / 1020	2m 46s / 5m 22s	`docker run ... @sha256:e3e58c6...`	Aug 16, 05:01
run 31927454842 executed 1020 - ccache 98 hit / 6525 miss - head 6095a2431 - digest sha256:e3e58c659e8620... - run 31927454842
success	1	20	1020 / 1020	2m 18s / 4m 21s	`docker run ... @sha256:d11d9fc...`	Aug 15, 05:01
run 31865238863 executed 1020 - ccache 98 hit / 6525 miss - head 1e488ffb1 - digest sha256:d11d9fc6d3750a... - run 31865238863
success	1	20	1020 / 1020	2m 48s / 4m 56s	`docker run ... @sha256:a54cb6c...`	Aug 14, 05:01
run 31770808095 executed 1020 - ccache 165 hit / 6458 miss - head d5f53f6c3 - digest sha256:a54cb6c35e6495... - run 31770808095
success	1	20	1020 / 1020	2m 55s / 5m 40s	`docker run ... @sha256:f32048c...`	Aug 13, 04:59
run 31667889763 executed 1020 - ccache 165 hit / 6458 miss - head 13a5274d4 - digest sha256:f32048c12070f0... - run 31667889763
success	1	20	1020 / 1020	2m 54s / 5m 26s	`docker run ... @sha256:59acace...`	Aug 12, 04:57
run 31564092523 executed 1020 - ccache 165 hit / 6455 miss - head 94374eb8a - digest sha256:59acace369fddf... - run 31564092523
success	1	20	1020 / 1020	2m 49s / 5m 07s	`docker run ... @sha256:2b24685...`	Aug 11, 04:56
run 31459269441 executed 1020 - ccache 165 hit / 6454 miss - head e59b235d3 - digest sha256:2b24685066a576... - run 31459269441
success	1	20	1020 / 1020	2m 48s / 5m 20s	`docker run ... @sha256:341b2c2...`	Aug 10, 04:55
run 31356259594 executed 1020 - ccache 166 hit / 6453 miss - head d3814a811 - digest sha256:341b2c2beb4e1a... - run 31356259594
success	1	20	1020 / 1020	2m 48s / 5m 06s	`docker run ... @sha256:0184cbc...`	Aug 08, 03:26
run 31236779569 executed 1020 - ccache 166 hit / 6453 miss - head 859b58e1a - digest sha256:0184cbc9839ded... - run 31236779569
success	1	20	1019 / 1019	2m 55s / 5m 39s	`docker run ... @sha256:4fd0a2a...`	Aug 07, 03:24
run 31143686806 executed 1019 - ccache 166 hit / 6453 miss - head 7ac87714a - digest sha256:4fd0a2afdc3e3c... - run 31143686806
success	1	20	1019 / 1019	2m 54s / 4m 59s	`docker run ... @sha256:9817ced...`	Aug 05, 21:33
run 31048304223 executed 1019 - ccache 166 hit / 6453 miss - head b4d113635 - digest sha256:9817cedc88d748... - run 31048304223
success	1	20	1019 / 1019	2m 57s / 5m 30s	`docker run ... @sha256:3fd3219...`	Aug 04, 21:32
run 30951916531 executed 1019 - ccache 166 hit / 6453 miss - head ac0ea6012 - digest sha256:3fd32191752773... - run 30951916531
success	1	20	1019 / 1019	2m 54s / 5m 29s	`docker run ... @sha256:70b30de...`	Aug 03, 21:29
run 30854104142 executed 1019 - ccache 166 hit / 6453 miss - head a679f23fe - digest sha256:70b30de453b15f... - run 30854104142
success	1	20	1018 / 1018	2m 17s / 4m 43s	`docker run ... @sha256:5ec0a96...`	Aug 02, 21:27
run 30767561778 executed 1018 - ccache 166 hit / 6453 miss - head f0700520d - digest sha256:5ec0a9634b914b... - run 30767561778
success	1	20	1018 / 1018	2m 15s / 4m 47s	`docker run ... @sha256:6416c45...`	Aug 01, 21:25
run 30718733511 executed 1018 - ccache 166 hit / 6453 miss - head 8767ad79d - digest sha256:6416c459c714ae... - run 30718733511
success	1	20	1018 / 1018	2m 54s / 5m 15s	`docker run ... @sha256:65d2e07...`	Jul 31, 21:24
run 30665823425 executed 1018 - ccache 166 hit / 6453 miss - head 17080575d - digest sha256:65d2e07a8dd709... - run 30665823425
tests failed	1	20	1016 / 1017	2m 47s / 5m 19s	`docker run ... @sha256:bb2c82a...`	Jul 30, 21:21
run 30582357779 failed: recovery/051_effective_wal_level executed 1017 - ccache 166 hit / 6453 miss - head 023683848 - digest sha256:bb2c82aa87951f... - run 30582357779
success	1	20	1017 / 1017	2m 39s / 4m 40s	`docker run ... @sha256:dbd30e4...`	Jul 29, 21:18
run 30491230060 executed 1017 - ccache 166 hit / 6453 miss - head e57a32ce3 - digest sha256:dbd30e45115654... - run 30491230060
success	1	20	1016 / 1016	2m 10s / 4m 22s	`docker run ... @sha256:a1bdde4...`	Jul 28, 21:19
run 30399350389 executed 1016 - ccache 166 hit / 6453 miss - head ca55bba17 - digest sha256:a1bdde4b59fea6... - run 30399350389
success	1	20	1014 / 1014	2m 57s / 5m 14s	`docker run ... @sha256:cfe32e6...`	Jul 27, 14:52
run 30276337437 executed 1014 - ccache 166 hit / 6453 miss - head 8f6d3909a - digest sha256:cfe32e6d1500f5... - run 30276337437