PostgreSQL production readiness
The gate before go-live for self-managed PostgreSQL.
Free excerpt
Authentication
Set password_encryption = scram-sha-256, use scram-sha-256 in pg_hba.conf, never trust for network entries, and set listen_addresses to what you need.
Roles
Separate owner, application and read-only roles. REVOKE CREATE ON SCHEMA public FROM PUBLIC; on older versions.
Backups with a restore drill
Base backups plus WAL archiving (for example pgBackRest) give point-in-time recovery. Schedule a restore test; an untested backup is not a backup.
Logging that helps
log_min_duration_statement, log_checkpoints, log_lock_waits; watch disk space, autovacuum and connections (max_connections vs. a pooler).
The paid checklist covers config, pg_hba/roles, pgBackRest with PITR, replication, vacuum, monitoring and upgrades for PostgreSQL 14–17.
Get the full pack
Sats Werkstatt
PostgreSQL Production Readiness ChecklistThe gate before go-live for self-managed PostgreSQL 14–17: config, pg_hba/roles, pgBackRest backups with PITR and restore drill, replication, vacuum, monitoring and upgrades. 10-page PDF, English. No warranty. Personal use only.
15,000 sats English
Buy with Lightning
PostgreSQL Production-Readiness-ChecklisteDas Tor vor dem Go-live: Konfiguration, pg_hba/Rollen, pgBackRest-Backups mit PITR und Restore-Übung, Replikation, Vacuum, Monitoring, Upgrades. PDF, Deutsch, 10 Seiten. Keine Gewähr. Nur zur eigenen Nutzung.
15,000 sats Deutsch
Buy with Lightning
Checklist de PostgreSQL listo para producciónLa puerta antes del go-live: configuración, pg_hba/roles, copias con pgBackRest y PITR, ejercicio de restauración, replicación, vacuum, monitorización y upgrades. PDF, español, 10 páginas. Sin garantía. Solo uso personal.
15,000 sats Español
Buy with Lightning
Checklist de PostgreSQL pronto para produçãoO portão antes do go-live: configuração, pg_hba/roles, backups pgBackRest com PITR e exercício de restauração, replicação, vacuum, monitoramento e upgrades. PDF, português, 10 páginas. Sem garantia. Apenas uso pessoal.
15,000 sats Português
Buy with Lightning