25 Kritik Kontrol · Üretim Öncesi8 min duration
Pre-Production (Go-Live) 25 Critical Database Readiness Checklist
Hardware, Security, Backup, and Observability Checks to Prevent First-Day Production Outages
Checklist Progress: 0 / 5
%0
Operating System & KernelCRITICAL
1. Linux vm.swappiness = 1 and vm.overcommit_memory = 2
Prevents aggressive kernel swapping and unexpected process termination by the OOM Killer.
sysctl -w vm.swappiness=1 sysctl -w vm.overcommit_memory=2
Operating System & KernelCRITICAL
2. Transparent Huge Pages (THP) Disabled
THP causes severe latency spikes and CPU stalls in memory-intensive relational engines.
echo never > /sys/kernel/mm/transparent_hugepage/enabled echo never > /sys/kernel/mm/transparent_hugepage/defrag
Security & PrivilegesCRITICAL
3. Application Using Superuser Role?
Applications must never connect via postgres or root. Enforce least-privilege dedicated roles.
CREATE USER app_user WITH PASSWORD 'super_secure_pw'; GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO app_user;
Backup & RecoveryCRITICAL
4. First Restore Drill Verified?
Verify that physical backups restore successfully onto an isolated sandbox server with point-in-time recovery.
pgbackrest --stanza=db-prod restore --type=time "--target=2026-10-27 12:00:00"
Observability & MetricsHIGH
5. pg_stat_statements or Performance Schema Enabled?
Required to track query latency, execution frequency, and buffer cache efficiency.
-- postgresql.conf shared_preload_libraries = 'pg_stat_statements' pg_stat_statements.track = all