Problem Using Perl with Postgres
I have installed postgresql 7.1.2 on my Solairs 2.7 box with the
with-perl option.
I did not have any compile errors.
When trying to run a simple perl program I get the following error:
$ tst.pl
Can't locate loadable object for module Pg in @INC (@INC contains:
/ufs/gnu/postgresql-7.1.2/src/interfaces/perl5
/usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris
/usr/local/lib/perl5/site_perl/5.005 .) at tst.pl line 4
BEGIN failed--compilation aborted at tst.pl line 4.
The third line in the program is
use lib '/ufs/gnu/postgresql-7.1.2/src/interfaces/perl5';
use Pg;
The following is how the perl package was installed in my system.
Any ideas?
Joe
$ perl -V
Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
Platform:
osname=solaris, osvers=2.7, archname=sun4-solaris
uname='sunos 5.7 generic_patch sun4u sparc sunw,ultra-1 '
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='gcc', optimize='-O', gccversion=2.8.1
cppflags='-I/usr/local/include'
ccflags ='-I/usr/local/include'
stdchar='char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define,
longdblsize=16
alignbytes=8, usemymalloc=y, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -lgdbm -ldl -lm -lc -lcrypt
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'
Characteristics of this binary (from libperl):
Built under solaris
Compiled at Jul 5 2001 10:56:01
@INC:
/usr/local/lib/perl5/5.00503/sun4-solaris
/usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris
/usr/local/lib/perl5/site_perl/5.005
.
$
My guess would be that the module wasn't installed correctly, or that Perl
can't find the PG so (libpgeasy.so, I think). One thing, you should not tell
Perl to look in the source build directory if you have installed it
correctly. Only if you are testing the build before installing does this
make any sense.
Are you using Mod_Perl? You often have to build with certain parameters,
such as DYNAMIC=1 and then rebuild Apache::Util.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
Show quoted text
From: condlej@chplink.chp.edu (Joe)
Organization: http://groups.google.com/
Date: 25 Sep 2001 07:36:44 -0700
To: pgsql-general@postgresql.org
Subject: [GENERAL] Problem Using Perl with PostgresI have installed postgresql 7.1.2 on my Solairs 2.7 box with the
with-perl option.
I did not have any compile errors.When trying to run a simple perl program I get the following error:
$ tst.pl
Can't locate loadable object for module Pg in @INC (@INC contains:
/ufs/gnu/postgresql-7.1.2/src/interfaces/perl5
/usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris
/usr/local/lib/perl5/site_perl/5.005 .) at tst.pl line 4
BEGIN failed--compilation aborted at tst.pl line 4.The third line in the program is
use lib '/ufs/gnu/postgresql-7.1.2/src/interfaces/perl5';
use Pg;The following is how the perl package was installed in my system.
Any ideas?Joe
$ perl -V
Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
Platform:
osname=solaris, osvers=2.7, archname=sun4-solaris
uname='sunos 5.7 generic_patch sun4u sparc sunw,ultra-1 '
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='gcc', optimize='-O', gccversion=2.8.1
cppflags='-I/usr/local/include'
ccflags ='-I/usr/local/include'
stdchar='char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define,
longdblsize=16
alignbytes=8, usemymalloc=y, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -lgdbm -ldl -lm -lc -lcrypt
libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'Characteristics of this binary (from libperl):
Built under solaris
Compiled at Jul 5 2001 10:56:01
@INC:
/usr/local/lib/perl5/5.00503/sun4-solaris
/usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris
/usr/local/lib/perl5/site_perl/5.005
.
$---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster