Items in Category: Database


« Older Posts


Announcing walctl for PostgreSQL Transaction Log Management

March 27th, 2014 | Published in Database, Tech Talk | 2 Comments


I’ve managed to convince my employer to open source one of the tools I recently wrote. That tool goes by the name of walctl, and I believe the importance of this kind of tool can not be overstated.

The PostgreSQL Write Ahead Log (WAL) files are key to crash recovery, point in time recovery, and all standby use not derived from streaming replication. WAL files are extremely critical to proper database operation. Yet their archival is treated as an afterthought. Some people use regular cp while others go as far as to use rsync to send data to a replica server.

This isn’t enough.


Tags: , , ,

Free Copy of Instant PostgreSQL Starter

June 5th, 2013 | Published in Database, News, Tech Talk | 13 Comments


Another free book giveaway? What, am I running a library here? Well, it turns out Packt liked [intlink id="review-instant-postgresql-starter"]my review[/intlink] of Instant PostgreSQL Starter so much, they want me host a short period where you can obtain your very own copy for the low, low price of $0.


Tags: , , , ,

Winning (Free eBooks) is Everything

May 21st, 2013 | Published in Database, News, Tech Talk | 4 Comments


It occurs to me I forgot to congratulate the winners of the free ebooks. So without further ado:


Tags: , , , , ,

Make pg_hba.conf Redundant by Using pg_hba.conf

May 10th, 2013 | Published in Database, Tech Talk | 2 Comments


Let’s face it, the pg_hba.conf file is a pain in the ass to use regularly. Sure, reloading the database will cause it to re-read this file, but with a lot of active users and frequent changes, this isn’t really tenable.

Luckily lurking deep within its bowels, PostgreSQL has a little-known feature that can easily be overlooked because it’s so humbly stated.


Tags: , ,

Free PostgreSQL Backup Book? Yes Please!

April 26th, 2013 | Published in Database, News, Tech Talk | 16 Comments


A little while ago, I wrote to the PostgreSQL general mailing list that I’d been approached by Packt Publishing to contribute a quick manual on doing PostgreSQL backups: Instant PostgreSQL Backup and Restore How-to. They’re the same guys who published Greg Smith’s PostgreSQL 9.0 High Performance book which everyone seems to swear by.


Tags: , , , , , ,

« Older Posts