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 […]