How to Resync Your PostgreSQL Database Pointer

By Dana Jones

If you’re working with PostgreSQL and you’ve recently gotten a UniqueViolation error, you may just need to correct an out-of-synce database pointer.

PostgreSQL 9.5 Upgrade with Homebrew

By Daniel Morrison

PostgreSQL 9.5 was released yesterday and has a lot of cool new features. If you’re on Mac OS X and using Homebrew, you can upgrade with the steps below.

A PostgreSQL Sandbox Using VIM and tmux

By Chris Rittersdorf

!If you’re like me, you’ve let ActiveRecord hold your hand for way too long. And when it comes time to write advanced PostgreSQL queries, you need to experiment in the REPL to find what you’re looking for. Add this trick to your toolbox to make working with the PostgreSQL REPL simpler.