Blog

Practical insights on PostgreSQL reliability, operations, backups, monitoring, and production database management.

March 04, 2026 postgresql upgrade postgis troubleshooting
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 full post →
February 18, 2026 PostgreSQL Administration PostGIS
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 in enterprise spatial systems.
Read full post →
February 06, 2026 backups disaster-recovery best-practices
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 full post →