Please install the postgresql adapter: `gem install activerecord-postgresql-adapter`

silent1mezzo picture silent1mezzo · Jul 27, 2010 · Viewed 26.8k times · Source

Possible Duplicate:
How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”

I'm trying to get Redmine working with postgres.

In my logs I keep seeing.

Please install the postgresql adapter: `gem install activerecord-postgresql-adapter`

After googling everyone said you needed to do gem install pg. But when I do gem list

actionmailer (2.3.5)
actionpack (2.3.5)
activerecord (2.3.8, 2.3.5)
activeresource (2.3.5)
activesupport (2.3.8, 2.3.5)
fastthread (1.0.7)
passenger (2.2.15)
pg (0.9.0)
postgres (0.7.9.2008.01.28)
postgres-pr (0.6.3)
rack (1.0.1)
rails (2.3.5)
rake (0.8.7)

You can clearly see that pg is already installed. Has anyone else found this issue or fixed it?

Answer

rolando picture rolando · Jul 28, 2010

make sure your db-adapter in database.yml is set to "postgresql". If still you have the same problem, then try using the pure-ruby adapter:

gem install postgres-pr

(make sure you uninstall the pg gem before... to avoid conflicts)

If it works, then it's a problem with the postgres gem. Anyway, for development purposes, using the pure-ruby gem is usually ok.