Re: Problem Using Perl with Postgres

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"

> From: condlej(at)chplink(dot)chp(dot)edu (Joe)
> Organization: http://groups.google.com/
> Date: 25 Sep 2001 07:36:44 -0700
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] 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
> .
> $
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>