« 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: , , ,

Review: PostgreSQL Server Programing

December 12th, 2013 | Published in Book, Review | 1 Comment

There comes a time in every DBA’s life, that he needs to add functionality to his database software. To most DBAs, and indeed for most databases, this amounts to writing a few stored procedures or triggers. In extremely advanced cases, the database may provide an API for direct C-language calls. PostgreSQL however, has gone above and beyond this for several years, and have continuously made the process easier with each iteration.

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: , , , ,

Review: Instant PostgreSQL Starter

May 27th, 2013 | Published in Book, Review | 4 Comments

As a newly minted Packt author, it makes sense that I might get a request to review one of their books from time to time. On this particular occasion, I have the opportunity to give a look at Instant PostgreSQL Starter by fellow PostgreSQL user and author Daniel K. Lyons.

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: , , , , ,

« Older Posts