Preferred adapter for PostgreSQL 8.3 on Rails 2.0.2

What is the preferred Active Record adapter for PostgreSQL 8.3 on
Rails 2.0.2 ?

Brian Adkins

Brian Adkins wrote:

What is the preferred Active Record adapter for PostgreSQL 8.3 on
Rails 2.0.2 ?

Brian Adkins

The post is old, but as of today I installed the gem postgres and
specified the adapter postgresql in database.yml everything is running
smoothly with Rails 2.1.1

If someone has a better setup, please let us know.

My bad, the gem postgres is no longer maintained since 2006.

I am now running with ruby-pg which was last updated on 14th October
2008.

Fernando Perez wrote:

My bad, the gem postgres is no longer maintained since 2006.

I am now running with ruby-pg which was last updated on 14th October
2008.

Heh. I was just going to mention ruby-pg. I believe that's the "right"
one now.

Peace.

Holy crap!!! How can I install ruby-pg when PostgreSQL is on another
box? The gem won't build without the --include=/...

I want to keep PostgreSQL and my Rails app separated. I am running
Debian Etch. Do I compulsory need to install a copy of the package
postgresql on my Rails server without actually using it?

In this case it is a good idea to install postgresql on your rails
box. Just don't initialize a database.

This way you get all the standard posgres tools and are able to use
the new ./script/dbconsole.

Mikel

Hi, yeas it is enough to install the dev libs for postgresql in order to
have ruby-pg compile. I remembered that for MySQL you just need to
install the dev libs in order to build the fqster mysql gem.

My app is now remotely communicating with PostgreSQL thanks to ruby-pg.