From: Wilson Bilkovich <wilsonb@...>
Date: 2006-01-27T06:13:18+09:00
Subject: Re: postgres database

On 1/26/06, Dave Howell <groups@grandfenwick.net> wrote:
>
> On Jan 24, 2006, at 18:23, Pat Maddox wrote:
>
> > You need to have the postgres adapter installed.  I made a blog
> > post[1] that covers installation.  It's pretty easy, just have to do a
> > few steps beyond the 'gem install postgres'.  You can probably skip
> > the step to symlink libpq-fe.h because I think that's FreeBSD
> > specific.  Naturally, you'll need to make sure you use the correct
> > paths for postgresql's include/lib dirs, where your gems are located,
> > etc.
>
> A suggestion to the wider PostgreSQL-using Ruby populace; I was
> somewhat confused until I figured out that I had to install at least
> part of Postgres (bits of library files, I think) on the machine
> running Ruby in order to talk to the database that's running on a
> different system.
>
> If somebody should happen to write/update/expand upon the instructions
> for installing Postgres support into Ruby to include the case where the
> Ruby code is being installed and/or running on a system without local
> Postgres, that'd probably be a good thing . . . :) Maybe some way to
> permanently bind the libraries into the gem-installed Ruby bits?
>
> [Stop me if I start talking nonsense, I'm not entirely sure what I'm
> talking about here.]
>

Personally, I just use the postgres-pr adapter, which is pure Ruby.
No dependencies, no compilation. Good stuff.