Please install the postgresql adapter: `gem install activerecord-postgresql-adapter` [duplicate]

Question

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 1

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.

Answer 2

I had more luck with the ruby-pg gem

gem install ruby-pg

I tried a number of the other gems 'postgres', 'pg', 'postgres-pr' with no luck My environment was Ubuntu 10.4, ruby enterprise 1.8.7

ruby-pg resolved the above issue for me

Answer 3

for debian squeeze it is:

aptitude install libdbd-pg-ruby