WAL archiving failures

Check Acrynite

$acrynite wal status production

Check PostgreSQL

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

Review

• Whether archive_mode is enabled.
• Whether a PostgreSQL restart is required.
• Whether wal_level is appropriate.
• Whether the PostgreSQL process can execute Acrynite.
• Whether the PostgreSQL process can read Acrynite configuration.
• Whether destination credentials work.
• Whether the archive command can run under the PostgreSQL service environment.