Re: Have problem about Perl DBI, Please help

Postgres' Perl support has nothing to do with DBI. You need to install
DBD::Pg to use postgres via DBI. If the postgres libs are in your ld lib
path you can install with the cpan shell (perl -MCPAN -e shell). If not, you
will have to set PGLIB, but you should still be able to use cpan.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

From: "BinYang" <byang(at)array(dot)ca>
Date: Fri, 19 Oct 2001 13:27:48 -0400
To: <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] Have problem about Perl DBI, Please help

Hello Support,

I encountered a problem related to the perl DBI of PostgresSQL. First, On my
Solaris 8 system I installed Perl 5.6.1 with plperl shared, and then
installed Postgresql 7.1.2 with perl choosed. I did not have problem during
these installition. However, when running a perl script for test I got a
message "Can't locate loadable object for module Pg in @INC. But I am sure
the lib directory of my Postgresql database is in this enviroment. Please
help as soon as possible, Thanks a lot.

Bin Yang

Output of perl ­v:

This is perl, v5.6.1 built for sun4-solaris Copyright 1987-2001, Larry Wall

Perl may be copied only under the terms of either the Artistic License or
the GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'. If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

Output of perl ­V:

Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:

Platform:

osname=solaris, osvers=2.8, archname=sun4-solaris

uname='sunos solaris 5.8 generic sun4u sparc sunw,ultra-5_10 '

config_args='-Dcc=gcc -de'

hint=recommended, useposix=true, d_sigaction=define

usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef

useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef

use64bitint=undef use64bitall=undef uselongdouble=undef

Compiler:

cc='gcc', ccflags ='-fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',

optimize='-O',

cppflags='-fno-strict-aliasing -I/usr/local/include'

ccversion='', gccversion='2.95.3 20010315 (release)',
gccosandvers='solaris2.8'

intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321

d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16

ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8

alignbytes=8, usemymalloc=y, prototype=define

Linker and Libraries:

ld='gcc', ldflags =' -L/usr/local/lib '

libpth=/usr/local/lib /usr/lib /usr/ccs/lib

libs=-lsocket -lnsl -lgdbm -ldb -ldl -lm -lc

perllibs=-lsocket -lnsl -ldl -lm -lc

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):

Compile-time options: USE_LARGE_FILES

Built under solaris

Compiled at Apr 26 2001 04:07:49

@INC:

/space/psql/pgsql/lib

/usr/local/lib/perl5/5.6.1/sun4-solaris

/usr/local/lib/perl5/5.6.1

/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris

/usr/local/lib/perl5/site_perl/5.6.1

/usr/local/lib/perl5/site_perl

.