Rambling Labs Blog Ramblings on software development

  • Using Postgresql with Rails 3.1: the 'pg' gem

    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!

  • blog comments powered by Disqus