WAL archiving monitoring
Keep an eye on WAL archiving so a silent failure does not break future recovery.
Check Acrynite and recovery points
$acrynite wal status production$acrynite recovery-points list --database production
Inspect PostgreSQL archiver statistics
SELECTarchived_count,failed_count,last_archived_wal,last_archived_time,last_failed_wal,last_failed_timeFROM pg_stat_archiver;
Investigate a rising failure count or a stale successful-archive timestamp.
A configured destination is not proof of continuous WAL archiving.
