Thread: Problem Using Perl with Postgres

Problem Using Perl with Postgres

From
condlej@chplink.chp.edu (Joe)
Date:
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
    .
$

Re: Problem Using Perl with Postgres

From
Keary Suska
Date:
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@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 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
>