PostgreSQL Reliability
Making production databases boring, reliable, and stress-free.
Core Practices
Specialized PostgreSQL practices focused on what matters most: reliability, performance, and peace of mind.
Backup & Recovery
Comprehensive backup strategies, disaster recovery planning, and tested restore procedures. Because a backup that's never been restored isn't a backup.
Monitoring & Alerts
Proactive monitoring systems that catch issues before they become problems. Smart alerting that reduces noise and focuses on what matters.
Performance Tuning
Query optimization, index strategies, and configuration tuning for production workloads. Making your database fast and keeping it that way.
Migrations & Upgrades
Zero-downtime migrations, version upgrades, and platform transitions. Careful planning and execution for critical database changes.
Health Audits
Comprehensive database health checks, security reviews, and best practice assessments. Know exactly where you stand.
Training & Support
Team training, documentation, and ongoing support. Empowering your team to manage PostgreSQL with confidence.
Latest Insights
Practical thoughts on PostgreSQL reliability, operations and production databases.
-
When pg_upgrade Passes Checks but Crashes During Upgrade: A PostGIS--PROJ Library Conflict
A PostgreSQL 13→16 upgrade where pg_upgrade --check passed but the actual upgrade crashed due to a PROJ library conflict used by PostGIS.
Read more → -
Backup and Restore Strategy for Large PostGIS Clusters
Logical dumps don’t scale for large PostGIS databases. This post breaks down physical backup strategy, WAL explosion risks, replication slot pitfalls, and why restore-time validation matters more than backup frequency...
Read more → -
Backups That Were Never Restored
A backup that has never been restored is not a backup. Here's why testing your PostgreSQL backups is just as critical as creating them.
Read more →