PostgreSQL Production Checklist

WAL archiving is enabled and pg_stat_archiver reports failed_count = 0 and a recent last_archived_time.

max_slot_wal_keep_size is set so an abandoned replication slot cannot fill the primary's disk.

An alert fires on inactive replication slots and on slots retaining more than a defined amount of WAL.

A full physical backup plus WAL archive supports point-in-time recovery, and the retention window is documented.

A restore has been performed into an isolated environment, with the elapsed time recorded against the RTO.

pg_dumpall --globals-only output is backed up: roles and grants are not in a per-database dump.

The extension list and their versions are recorded alongside the backup.