Converting a ruby on rails app from sqlite to postgresql

Question

I am going to use thinking sphinx for my application and it requires a conversion to postgresql. I have downloaded both sphinx and postgresql using homebrew, but I am unsure how to convert the rest of the application. I do not care about saving my data, as I only have about 5 records in my database. If there is a step by step guide, or a resource that could guide me I would appreciate it.

Answer 1

It's a very simple process if you have stuck to using activerecord and not used any custom SQL.

All you'll need to do is change your gemfile to include gem 'pg' and change the database.yml file to have something like the following:

  development:
    adapter: postgresql
    database: example_development
    username: postgres
    password: secret
    host: localhost
    encoding: UTF8

If you have used custom SQL, you'll just need to convert it to PostgreSQL, which shouldn't be too tricky as it's very similar.

Answer 2

http://devcenter.heroku.com/articles/database#common_issues_migrating_to_postgresql

Answer 3

I used the following video from Peter Cooper to figure out what I was doing wrong. If anyone needs to set up Postgresql in the future reference this: http://www.youtube.com/watch?v=pf5jPUJAeU4