I definitely would suggest using DBI and DBD::Pg rather than the Pg module that comes with Postgres.

I've used both, and while Pg.pm gives you more of a straight forward approach with reagard to the Postgres API, DBI is so much nicer to use. I have to say, DBI is a pretty damn well thought out general database interface.

Plus it seems that on some very specific installations, Pg.pm barfs when it comes to large objects. :-(

Anyway, you will need the Postgres source to compile DBD::Pg. So get the tar ball, rather than the binary...