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.