Rails3 + PostgreSQL

rubyonrails-talk
1

Anyone know if Rails 3 supports PostgreSQL yet? I'm again trying on the latest beta, still not getting anything to work.

I have every postgresql gem I can find installed:

gem list --local|grep ^p

pg (0.9.0) postgres (0.7.9.2008.01.28) postgres-pr (0.6.3)

My database.yml entry:

development:   adapter: postgresql   database: rails3_dev   username: rails3   password: rails3

Then when I try it, I get this:

RuntimeError (Please install the postgresql adapter: `gem install activerecord-postgresql-adapter` (no such file to load -- pg)):

I'm not finding a gem by that name:

gem install activerecord-postgresql-adapter

ERROR: could not find gem activerecord-postgresql-adapter locally or in a repository

This page doesn't even mention that gem:

http://wiki.rubyonrails.org/database-support/postgres

Anyone get this to work yet?

2

Yeah it works fine, worked since the first beta.

On Ubuntu these are the packages I installed:

sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev

Then all you need is the pg gem mentioned in your Gemfile.

Maybe the fact you have the others installed is part of the problem, they are definitely not required for it to work, this is the only PostGres related gem I have in my Gemfile:

gem "pg"

3

That was the problem. It works fine when pg is the only gem installed. Thanks.

4

Hi… i called Carina… i was either problem installed its gem…

5

For me this helped to. Additionally I had to add "require 'pg'" to the Gemfile. Thanks.