Re: Implementing mod_perl, Perl 5.004, and Postgres

I am posting this because it will probably help someone else out. There are about a zillion different
flavors of the Pg.pm. This has proven to be a real hair-puller for me and I am hoping this saves
someone else some time.

To Dana: Thanks for pointing me in the right direction. I haven't had time until now, to really get
my teeth back into this thing again. I tried to install it from the command line as you suggested,
but CPAN says that it isn't sure which module I want. I searched manually and found 3 that would seem
to qualify. I have tentatively ruled out the third one because I am running 7.0.2 and not 95.
However, this leaves me with items 1 and 2.

As soon as I determine which one is really "it", I will add to this posting to let everyone know. In
the mean time, someone might want to mention this in the FAQ somewhere, especially if they know which
module is "correct" or have some way to differentiate between all of them. More reading and empirical
testing on the way.

PgSQL-0.51: "Pure perl" interface to PostgreSQL [ download / quickinstall ]
CPAN directory: G/GT/GTHYNI (Göran Thyni)
Category >> Database Interfaces >> PgSQL

perl: Perl5 extension for PostgreSQL [ download / quickinstall ]
CPAN directory:M/ME/MERGL (Edmund Mergl)
Category >> Database Interfaces >> Pg

Postgres-1.4: Perl interface to the Postgres95 SQL database engine [ download / quickinstall ]
CPAN directory: V/VK/VKHERA (Vivek Khera)
Category >>Database Interfaces >> Postgres

Dana Hudes wrote:

> Do you have Pg installed?
> that's the Perl interface to Postgres and it is apparently not part of the build from the RPM set.
> so go to CPAN and install in the usual manner i.e., as root :
> perl -MCPAN -eshell
> install Pg
> quit
>
> ----- Original Message -----
> From: "Jimi Thompson" <jthompson(at)link(dot)com>
> To: <pgsql-admin(at)postgresql(dot)org>
> Sent: Thursday, November 09, 2000 4:25 PM
> Subject: [ADMIN] Implementing mod_perl, Perl 5.004, and Postgres
>
> > I am trying to get Postgres to accept Perl as an interface. I am
> > running Apache 1.3.14, Perl 5.004_04, and mod_perl. My application is a
> > help desk/call ticketing system called Teacup
> > (http://www.altara.org.teacup.html) which is written in Perl. It's a
> > series of CGI scripts which allow input, queries, etc. to a Postgres
> > back-end.
> >
> > Each of my components (apparently) works fine individually. Apache is
> > displaying pages and will run perl and cgi scripts. Perl is operating in
> > and outside Apache. Mod_perl is working just fine. My problem is in
> > trying to use Perl to access Postgres.
> >
> > I keep getting error messages from my CGI scripts regarding a file
> > called Pg.pm. Since this appears to be a perl module, I was wondering
> > if anyone knows how to go about making Perl and Postgres like each other
> > :)
> >
> > Jimi Thompson
> > L3 communications
> >
> > "It's the same thing we do every night, Pinky."
> >
> >

--
Jimi Thompson
Web Master
L3 communications

"It's the same thing we do every night, Pinky."