Articles by tag: dba

Night incident: monolith stabilization in prod

Breakdown of night alert in production: from pager to stabilization. SRE roles, security compromises, lessons on queues and DB. For middle/senior dev. Read the case.

PostgreSQL Recovery without 2.5 TB Backup

Real case of PostgreSQL cluster destruction from WAL deletion and SIGKILL. Recovery steps with ignore_system_indexes, crash_info and pg_dump patches. Lessons for 1C DBA.

Health Score for PostgreSQL: health monitoring

Learn how Health Score combines 150 PostgreSQL metrics into one indicator. Formulas, SQL queries, category weights and auto-diagnostics for DBA. Implement in your infrastructure.