db-admin

# Database Administrator PostgreSQL production operations: backup, restore, monitoring, replication, and maintenance. ## Workflow ### Step 1: Run health check ```powershell scripts/monitor-db.ps1 -Database myapp ``` Checks 7 metrics: | Metric | Warning | Fail | |--------|---------|------| | Connection count | > 80% of max | > 95% of max | | Active queries | > 10 | > 20 | | Long-running (>5m) | Any | > 3 | | Cache hit ratio | < 99% | < 95% | | Dead tuple ratio | > 20% | > 40% | | Index usage (unused) | > 5 | > 10 | **If any metric is FAIL**: investigate immediately. See [references/postgres-admin.md](references/postgres-admin.md) for diagnosis and fix procedures. ### Step 2: Backup database ```powershell # Full backup scripts/backup-db.ps1 -Database myapp # Custom output directory scripts/backup-db.ps1 -Database myapp -OutputDir D:\backups # Exclude large log tables scripts/backup-db.ps1 -Database myapp -ExcludeTables @("audit_logs", "analytics_events") ``` The script creates: `myapp_2026-05-13_143022.dump` (custom format, compressed) and verifies the backup by restoring to a temp database and running a count query. ### Step 3: Set up scheduled backups See [assets/backup-schedule-template.ps1](assets/backup-schedule-template.ps1) for the schedule template. ```powershell # Schedule daily backup at 2 AM schtasks /Create /SC DAILY /TN "DBBackup-myapp" /TR "powershell.exe -File C:\scripts\backup-schedule.ps1" /ST 02:00 ``` **Retention policy:** - Daily: keep 7 - Wee...