Description
I want to find out when the last successfull wal archive backup was made (being pushed by archive-push from db server), and what the last (newest) possible restore time would be. To centrally control that backups are being made correctly.
pg_probackup-11 show -B /var/lib/pg-probackup-11/ --archive
Doesn't seem to show that, neither does
pg_probackup-11 show -B /var/lib/pg-probackup-11/
This one only shows the timestamp of when the full/incremental/page backup was made.
I could just verify the date of the last .wal archive in the wal directory (and hope it was copied completely, and all the previous one were also copied completely).
But it would be easier if one of the commands would return that. So I can send warning messages in case there wasn't a successful wal archive backup in x hours/days/... .
Also it would make it easier to manually control when the last wal file was copied.