It occurs to me I forgot to congratulate the winners of the free ebooks. So without further ado: SAB, who seems to host a nice blog geared toward server administration. Stephan, who’s looking to improve existing strategies. Jeff and his growing PostgreSQL cluster. Pierre, who apparently has an experimental PostgreSQL backend for MySQL. Interesting. Congrats to the winners. But more, I call upon them to pay it forward by contributing to the community, either by corresponding with the excellent PostgreSQL mailing lists, or maybe submitting a patch or two to the code.

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. Here’s the manual entry for pg_hba.conf for the user section:

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. The goal of the backup book was to distill the PostgreSQL documentation, tools, and Wiki down to a collection of short step-by-step guides much like the O’Reilly nutshell series.

Mid March is an interesting time of year in 2013. Now that the Galaxy S4 has been announced, there are really three major contenders for my itchy spending finger. Well, technically there are four, but one of them doesn’t really count, for reasons I’ll expound upon shortly. Google Nexus IV This is the phone that doesn’t count. One major benefit it has over all of the others, is that it gets updates directly from Google.

About a week ago, I was prescribed Lexapro. While this may not be the stuff I’m on long-term, it’s still long overdue for reasons obvious to anyone who knows me. What I currently find most interesting about it however, is actually related to a dream I had last night. My dreams tend to be very vivid and numerous, though sometimes they follow a theme or storyline. Last night, there was one particular scene I recall with such clarity, it’s almost difficult to accept I wasn’t awake.