Tech Talk

Make pg_hba.conf Redundant by Using pg_hba.conf

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:

Free PostgreSQL Backup Book? Yes Please!

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.

Phone, Phone on the Range

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.

Long Time, no Me. Android, Weeee?

Yes, I’m still alive. Just in case you were wondering. With that out of the way, I’ve been enjoying my Sprint Galaxy S2 variant immensely. It feels orders of magnitude faster and more powerful than my old Android Eris. And really, the stats reflect about a 4x multiplier over every attribute of the Eris. It took some getting time to mentally transition from a 3.2" screen to a 4.5" screen, but I did it.

2011 PGOpen is now Closed

Well, that was an interesting couple of days. Unfortunately my birthday came right after and I didn’t feel like writing anything for the duration. Now though? Why not! In the end, I think my presentation, NVRam for Fun and Profit went over okay. Not a ton of people showed up, but I did get ambushed afterwards with questions after I got off the stage. Why those people didn’t ask while I was in Presentation Mode, I can’t quite understand.