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

pg_archivecleanup currently takes a WAL file name as input to delete

the WAL files prior to it [1]. As suggested by Satya (cc-ed) in

pg_replslotdata thread [2], can we enhance the pg_archivecleanup to

automatically detect the last checkpoint (from control file) LSN,

calculate the lowest restart_lsn required by the replication slots, if

any (by reading the replication slot info from pg_logical directory),

archive the unneeded (an archive_command similar to that of the one

provided in the server config can be provided as an input) WAL files

before finally deleting them? Making pg_archivecleanup tool as an

end-to-end solution will help greatly in disk full situations because

of WAL files growth (inactive replication slots, archive command

failures, infrequent checkpoint etc.).