From: Dave Lee <davelee.com@...>
Date: 2006-01-26T00:56:30+09:00
Subject: Re: PostgreSQL in Ruby with SSL connections

On 1/24/06, Kevin Brown <blargity@gmail.com> wrote:
> I'd like to use SSL certificate authentication, and that happens
> transparently?  Don't I need to supply a cert?  It's not looking in the
> ~/.postgresql directory for it like psql does...?

If you are using postgres-pr, than I can't comment.  If you are using
the ruby-postgres extension, then it too should be looking in the
~/.postgresql directory because, as mentioned by Dick Davies,
ruby-postgres makes use of  libpq, which is what psql uses.  The
documentation regarding ssl support in libpq is at:

http://www.postgresql.org/docs/current/interactive/libpq-ssl.html

which states:

"If the server demands a client certificate, libpq will send the
certificate stored in file ~/.postgresql/postgresql.crt within the
user's home directory. A matching private key file
~/.postgresql/postgresql.key must also be present, and must not be
world-readable."

Having said this, I haven't actually used ssl for postgresql
connections.  The documentation regarding ssl with libpq is very
simple, I'm not sure what could be going wrong in your case.  Which
OS?  Which ruby?  Which version of ruby-postgres?  Maybe you're
actually using postgres-pr?

Dave