Operations & Runbook Library

Database Operations & Runbook Hub

Daily DBA operations, incident triage procedures, reference topologies, and performance optimization recipes.

Verify Your PostgreSQL Backup: The First Restore Drill

Taking backups is not enough. Sandbox provisioning, pg_restore & PITR, amcheck verification queries, and signed audit report.

Production-ready SQL queries for status, indexes, backups, and lock triage.

Step-by-step incident runbooks, rollback plans, and triage communication templates.

Battle-tested reference topologies: Patroni HA, Always On AG, and Replica Sets.

Point-In-Time Recovery, RPO/RTO calculations, and disaster restore drills.

Index optimization, memory buffer pool sizing, and query EXPLAIN plans.

Key metrics, alert thresholds, and Prometheus/Datadog monitoring rules.