Using Postgresql with Rails 3.1: the 'pg' gem

October 17, 2011

This post was originally published in the Rambling Labs Blog on October 17, 2011.

As you may know I’ve been learning Ruby on Rails for the last few weeks. I’m also currently developing an application using the edge version of RefineryCMS (which is really a Rails 3.1 application), integrated with the almighty Heroku.

I wanted to use RefineryCMS with Postgresql, so the only thing that I had to do was installing postgresql and it’s corresponding gem ‘pg’… Or so I thought.

I wasn’t surprised. About a year ago I had the same unfulfilled expectations with mysql and the mysql gem. So, this is what I had to do:

  • First, of course, install postgresql with apt-get install postgresql
  • Then, install the libpq-dev with apt-get install libpq-dev. Note that it’s “pq” and not “pg” as you would probably expect.
  • Finally, install the “pg” gem with gem install pg

With that done, you should be ready to go. :) Enjoy!