Preferred adapter for PostgreSQL 8.3 on Rails 2.0.2

Rails
1

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

Brian A.

2

Brian A. wrote:

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

Brian A.

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.

3

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.

4

Fernando P. 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.

5

For some strange reason, if I specify:

config.gem ‘ruby-pg’

in environment.rb, Rails can’t find the gem although it is installed on
the system. Any idea?

6

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?

7

Mikel L. wrote:

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

I’m curious if it would be sufficient to install the development
libraries. I haven’t tried that before, so the development libraries
might be dependent on the run-time libraries, so you’d have to have it
anyway. It’s probably worth looking into, though.

Peace.

8

On Mon, Oct 20, 2008 at 3:10 AM, Fernando P.
[email protected] wrote:

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

–

Rails, RSpec and Life blog…

9

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.