postgres Updating PostgreSQL 9.1 to 9.3 in Ubuntu This was written a while back on Roon.io, and now 9.4 is out with better JSON support. Ubuntu Probably somewhat similar to this. I would reference this gist as a starting point. Bonus: OSX I would recommend upgrading to that using Heroku's