Re: getting perl to talk to postgres

Frederick,
I am fairly new to installing Perl but have done it successfully. I am more
of a developer vs. a *nix sysadmin/installation expert. I usually work on
systems that have already had this stuff done.

I would have to say that you probably will not be successful installing this
as the postgres user. pg user has very little access on the box. I think
that this ID is only supposed to be used to start the postmaster and run
psql (and related pg programs). Installation of software requires much more
access than this user has. From your error it looks like you are having
permissions issues. Don't fret.

Have you tried CPAN? CPAN is a Perl installation system. Go to www.cpan.org.
There are provisions in this system for almost all databases including
PGSQL. I have successfully installed Perl/Postgres libraries(for Perl) on
about 8 boxes with this system and had no problems except for my own lack of
knowledge about what I really needed. I installed this stuff as root.
Everyone feel free to jump in and let me know if this is a bad thing...

Perl runs from my web pages as www or nobody users (depending on who set up
the original box) and connects to PostGreSQL as a user that I define.

I have the feeling you will be up in no time... CPAN rocks and it works very
well for me. It hasn't let me down yet. I am running Red Hat 7 with some SCO
thrown into the mix, on x86 (Pentium, PII and PIII) boxes.

thx,
Neil

----- Original Message -----
From: "faroxy" <frederick(dot)opp(at)home(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Sent: Thursday, January 04, 2001 10:46 PM
Subject: [INTERFACES] getting perl to talk to postgres

> I am trying to get perl to talk to postgres but the installation of DBI
> is proving to be a headache. I am installing DBI-1.14, but when I run
> "perl Makefile.PL" as the postgres user, I get the following error :
>
> [postgres(at)cr833060-a DBI-1.14]$ perl Makefile.PL
> Checking if your kit is complete...
> Looks good
> Writing Makefile for DBI
> Unable to open MakeMaker.tmp: No such file or directory at
> /usr/lib/perl5/5.6.0/ExtUtils/MakeMaker.pm line 756.
>
> I read in a previous posting addressing a similar problem that it could
> be because the user (postgres) does not have permission to write to the
> directory containing the perl source. I have used "chown" to make sure
> postgres can write to that directory but I get the same error. Can
> anyone advise me on how to get the makefile to work?
>
> system specs: RedHat 7.0; Postgres 7.0.2; DBI-1.14; Perl,
> v5.6.0 built for i386-linux .
>
> Thanks in advance for any help.
> Frederick.
>
>