Sats Coop catalog

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