Blogacrynite.com

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

SELECT
archived_count,
failed_count,
last_archived_wal,
last_archived_time,
last_failed_wal,
last_failed_time
FROM pg_stat_archiver;

Investigate a rising failure count or a stale successful-archive timestamp.

A configured destination is not proof of continuous WAL archiving.