ArmorDB engineering
Practical PostgreSQL, without the noise.
Clear guides for running, securing, and scaling PostgreSQL in production—from quick fixes to deeper architecture decisions.
105
Field notes, comparisons, and operational guides.
Latest writing
Recently published
A focused selection from the full archive, ordered by publication date.
Where to Store Database Backups So You Can Still Restore After an Outage
Learn where to store database backups for fast restores and real resilience. A practical 3-2-1 storage guide for small teams.
How Long Should You Keep Database Backups? Build a Retention Policy You Can Defend
Learn how long to keep database backups, what affects retention, and a simple tiered schedule for daily, weekly, and long-term copies.
How Often Should You Back Up Your Database? Set a Schedule You Can Trust
Wondering how often to back up your database? Learn to set backup frequency using RPO, with practical schedules and a review checklist.
How to Keep One Database Backup Ransomware Can't Touch
Learn how to protect database backups from ransomware with isolation, immutability, and off-site storage you can restore.
How to Be Sure Your Database Backup Will Actually Restore
Worried your database backup won't restore? Follow this practical test-and-recover process to avoid failed restores and downtime.
Fix PostgreSQL: sorry, too many clients already
Learn how to diagnose PostgreSQL connection-limit errors, distinguish leaks from traffic spikes, and fix them safely with pool sizing and PgBouncer.
PostgreSQL 18 VACUUM and ANALYZE Inheritance Change: What to Check
PostgreSQL 18 changes VACUUM and ANALYZE behavior for inherited parent tables. Learn how to audit maintenance scripts before a managed database upgrade.
PostgreSQL Extension Policy for Managed Databases
Compare PostgreSQL extension choices for managed databases, including contrib modules, trusted extensions, provider support, custom code, and external services.
Fix PostgreSQL: cannot execute INSERT in a read-only transaction
Learn why PostgreSQL reports a read-only transaction, how to confirm whether you are on a replica or read-only session, and the safest fix for managed databases.
PostgreSQL Memory Tuning in Managed Databases: A Practical Deep Dive
A practical guide to PostgreSQL memory tuning for managed databases, covering work_mem, shared buffers, temp files, connection pools, and safe diagnosis.
PostgreSQL 18 Upgrade Checklist for Managed Databases
Plan a PostgreSQL 18 upgrade for managed databases: review compatibility, checksums, MD5 changes, pg_upgrade statistics, COPY behavior, and rollout risks.
PostgreSQL Online Schema Change Options Compared
Compare PostgreSQL online schema change patterns for production apps: concurrent indexes, staged constraints, nullable columns, backfills, and maintenance windows.
Explore the archive
Browse by format
Deep dives
Long-form technical articles with real operational depth, benchmarks, and practical decision-making for PostgreSQL teams.
Quick fixes
Compact how-to articles that solve a single error, syntax problem, or connection issue quickly and precisely.
Comparisons
Structured comparisons, feature breakdowns, and decision guides closely aligned with managed PostgreSQL use cases.
News & trends
Current database news, release notes, and trend-driven updates with an eye on how they affect managed PostgreSQL teams.
Ready to put the guides into practice?
Start with managed PostgreSQL, PgBouncer, and a free plan that does not require a credit card.