Tag Archives: postgresql

Verify PostgreSQL Backups using Python and LXC


It’s well understood that backing up your database is, arguably, the single most important step in preventing data loss and building redundancy into your application. A thoroughly redundant backup plan will include having replica servers on standby and filesystem level backups for disaster recovery. The second most important step is verifying those same backups. Unfortunately, […]

Five Simple PostgreSQL Optimizations for Improving Performance


The Open Source PostgreSQL database is one of the most popular relational databases. More and more Web developers and DBAs are choosing PostgreSQL for it’s stability and reliability. The out-of-the-box install of PostgreSQL is good, but a few basic configuration changes can make it much faster while using fewer system resources. Tuning a database can be overwhelming […]