From: Anton 'tony' Bangratz <tony@...>
Date: 2006-06-14T19:14:53+09:00
Subject: Re: Ruby + Postgresql

--------------enig3BCC8130D83FC5806A4BE751
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Tom Allison wrote:
> First, I installed DBD/DBI for my Debian box and I'm not finding
> anything that looks like ri docs.  I haven't any idea what to do about
> this and am hoping that maybe it will just go away for now.  I doubt it=

> will.
>=20
> I don't know if this is a Debian problem or what.  So I'm putting it
> aside for now.

It is a Debian annoyance, the output of 'aptitude show ruby1.8' states
clearly:

On Debian, Ruby 1.8 is provided as separate packages.  You can get
full Ruby 1.8 distribution by installing following packages.

  ruby1.8 ruby1.8-dev ri1.8 rdoc1.8 irb1.8 ruby1.8-elisp
  ruby1.8-examples libdbm-ruby1.8 libgdbm-ruby1.8 libtcltk-ruby1.8
  libopenssl-ruby1.8 libreadline-ruby1.8

This information can be found on various sites, and even with
searching the mailing list archives for 'debian' and 'ruby'.


Other packages you might want to install are

libdbi-ruby1.8
libdbd-pg-ruby1.8

>=20
> What I would like to know is how to connect to a postgres database
> that's located on a TCP/IP connection (on another machine).  So far, th=
e
> docs I can find are a little vague on this department or are all about
> MySQL which doesn't really help.
>=20
>=20

It's only about replacing 'MySQL' with 'Pg':

dbh =3D DBI.connect('DBI:Pg:test:hostname', 'user', 'password')

alternatively

dbh =3D DBI.connect('DBI:Pg:database=3Dtest;host=3Dhostname',\
'user','password')

HTH,

t.

--=20
Anton Bangratz - Key ID 363474D1 - http://tony.twincode.net/
fortune(6):
When the government bureau's remedies don't match your problem, you
modify the problem, not the remedy.


--------------enig3BCC8130D83FC5806A4BE751
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQEUAwUBRI/higgZMsE2NHTRAQKPOgf2POHm0s+CDk20dJLBsN0ArhUsEFDqRUMu
RFF2PQ+Y82qthQoMIfE9amwUXiFxxBrAiTQhh6v7HP3cxsL5mY7YZmnUj754ON05
iEmVvDslw8G0ppYqNv+heHian2/ce5Eu6gOJTtHepcQ7Fw6hXB8faYdViom/htAE
5rrC14DGhE3CAbKfrOUszd2B45Fdk4pT7A7El5qCpp26lqNTQ7rdBTJueSlZlosS
bAxNg9Xc7+2NPFxcxNF2DxpbvSDDtrmH9WvFSDWZzAPr+Kegywa+IM8JXxsPB8ZJ
RSR6A7JZ8DWUFADYK6sufe02MXGFyhCRG6IDWft4f4JDbYOMbLfA
=kklv
-----END PGP SIGNATURE-----

--------------enig3BCC8130D83FC5806A4BE751--