help with pgsql_perl5-1.9.0 - Mailing list pgsql-interfaces

<div class="">I have been attempting to install pgsql so I can make use of the old Pg commands, otherwise I have
thousandsof lines of code in hundreds of cgi scripts which I am going to have to modify.  I successfully installed this
sameversion  on another Centos 6 server about a year ago  and it compiled and works correctly.  This is on a new server
Iam attempting to put into service, and need to get it running ASAP.  </div><div class=""><br class="" /></div>I have
beenunable to do a successful make on the software, I get<div class=""><div class="" style="margin: 0px; font-size:
14px;line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">LD_RUN_PATH="/usr/lib/../lib64" cc  -shared -O2
-L/usr/local/lib-fstack-protector Pg.o  -o blib/arch/auto/Pg/Pg.so <span class="Apple-tab-span"
style="white-space:pre"></span>\</b></span></div><div class="" style="margin: 0px; font-size: 14px; line-height:
normal;font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass=""><span class="Apple-tab-span" style="white-space:pre"> </span>  
-L/usr/local/pgsql/include-lpq  <span class="Apple-tab-span" style="white-space:pre"> </span>\</b></span></div><div
class=""style="margin: 0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color:
rgb(255,255, 255); min-height: 16px;"><span class="" style="font-variant-ligatures: no-common-ligatures"><b
class=""><spanclass="Apple-tab-span" style="white-space:pre"> </span>  </b></span></div><div class="" style="margin:
0px;font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span
class=""style="font-variant-ligatures: no-common-ligatures"><b class="">/usr/bin/ld: cannot find
-lpq</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family: 'Courier New';
background-color:rgb(255, 255, 255);"><span class="" style="font-variant-ligatures: no-common-ligatures"><b
class="">collect2:ld returned 1 exit status</b></span></div><div class="" style="margin: 0px; font-size: 14px;
line-height:normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">make: *** [blib/arch/auto/Pg/Pg.so] Error
1</b></span></div><divclass=""><span class="" style="font-variant-ligatures: no-common-ligatures">After getting the
errorthe first time, I removed the old perl and installed the latest version</span></div><div class=""><span class=""
style="font-variant-ligatures:no-common-ligatures">per the instructions in the README</span></div><div class=""><span
class=""style="font-variant-ligatures: no-common-ligatures">pgsql_perl5-1.9.0</span></div><div class=""><span class=""
style="font-variant-ligatures:no-common-ligatures"><div class="" style="margin: 0px; font-size: 14px; line-height:
normal;font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><br class="" /></div></span></div><div
class=""><spanclass="" style="font-variant-ligatures: no-common-ligatures"><b class="">perl -v</b></span></div><div
class=""><spanclass="" style="font-variant-ligatures: no-common-ligatures"><div class="" style="margin: 0px; font-size:
14px;line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">This is perl 5, version 24, subversion 0 (v5.24.0) built
forx86_64-linux</b></span></div><div class=""><span class="" style="font-variant-ligatures: no-common-ligatures"><b
class=""><brclass="" /></b></span></div></span></div><div class=""><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">perl -V</b></span></div><div class=""><span class="" style="font-variant-ligatures:
no-common-ligatures"><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family: 'Courier New';
background-color:rgb(255, 255, 255);"><span class="" style="font-variant-ligatures: no-common-ligatures"><b
class="">Summaryof my perl5 (revision 5 version 24 subversion 0) configuration:</b></span></div><div class=""
style="margin:0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255,
255);min-height: 16px;"><span class="" style="font-variant-ligatures: no-common-ligatures"><b class=""> 
 </b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family: 'Courier New';
background-color:rgb(255, 255, 255);"><span class="" style="font-variant-ligatures: no-common-ligatures"><b class=""> 
Platform:</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family: 'Courier
New';background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures: no-common-ligatures"><b
class="">   osname=linux, osvers=2.6.32-642.11.1.el6.x86_64, archname=x86_64-linux</b></span></div><div class=""
style="margin:0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255,
255);"><spanclass="" style="font-variant-ligatures: no-common-ligatures"><b class="">    uname='linux <a class=""
href="http://tp2.keyweb.com">tp2.keyweb.com</a>2.6.32-642.11.1.el6.x86_64 #1 smp fri nov 18 19:25:05 utc 2016 x86_64
x86_64x86_64 gnulinux '</b></span></div><div class="" style="margin: 0px; font-size: 14px; line-height: normal;
font-family:'Courier New'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    config_args='-de'</b></span></div><div class="" style="margin: 0px; font-size:
14px;line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">    hint=previous, useposix=true,
d_sigaction=define</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    useithreads=undef, usemultiplicity=undef</b></span></div><div class=""
style="margin:0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255,
255);"><spanclass="" style="font-variant-ligatures: no-common-ligatures"><b class="">    use64bitint=define,
use64bitall=define,uselongdouble=undef</b></span></div><div class="" style="margin: 0px; font-size: 14px; line-height:
normal;font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    usemymalloc=n, bincompat5005=undef</b></span></div><div class="" style="margin:
0px;font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span
class=""style="font-variant-ligatures: no-common-ligatures"><b class="">  Compiler:</b></span></div><div class=""
style="margin:0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255,
255);"><spanclass="" style="font-variant-ligatures: no-common-ligatures"><b class="">    cc='cc', ccflags ='-fwrapv
-fno-strict-aliasing-pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-D_FORTIFY_SOURCE=2',</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal;
font-family:'Courier New'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    optimize='-O2',</b></span></div><div class="" style="margin: 0px; font-size: 14px;
line-height:normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">    cppflags='-fwrapv -fno-strict-aliasing -pipe
-fstack-protector-I/usr/local/include'</b></span></div><div class="" style="margin: 0px; font-size: 14px; line-height:
normal;font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    ccversion='', gccversion='4.4.7 20120313 (Red Hat 4.4.7-17)',
gccosandvers=''</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678,
doublekind=3</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16,
longdblkind=3</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    alignbytes=8, prototype=define</b></span></div><div class="" style="margin: 0px;
font-size:14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">  Linker and Libraries:</b></span></div><div class=""
style="margin:0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255,
255);"><spanclass="" style="font-variant-ligatures: no-common-ligatures"><b class="">    ld='cc', ldflags ='
-fstack-protector-L/usr/local/lib'</b></span></div><div class="" style="margin: 0px; font-size: 14px; line-height:
normal;font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    libpth=/usr/local/lib /usr/lib /lib/../lib64 /usr/lib/../lib64 /lib /lib64
/usr/lib64/usr/local/lib64 /usr/local/lib /usr/lib</b></span></div><div class="" style="margin: 0px; font-size: 14px;
line-height:normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">    libs=-lpthread -lnsl -lgdbm -ldb -ldl -lm -lcrypt
-lutil-lc</b></span></div><div class="" style="margin: 0px; font-size: 14px; line-height: normal; font-family: 'Courier
New';background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures: no-common-ligatures"><b
class="">   perllibs=-lpthread -lnsl -ldl -lm -lcrypt -lutil -lc</b></span></div><div class="" style="margin: 0px;
font-size:14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">    libc=libc-2.12.so, so=so, useshrplib=false,
libperl=libperl.a</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    gnulibc_version='2.12'</b></span></div><div class="" style="margin: 0px; font-size:
14px;line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">  Dynamic Linking:</b></span></div><div class=""
style="margin:0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255,
255);"><spanclass="" style="font-variant-ligatures: no-common-ligatures"><b class="">    dlsrc=dl_dlopen.xs, dlext=so,
d_dlsymun=undef,ccdlflags='-Wl,-E'</b></span></div><div class="" style="margin: 0px; font-size: 14px; line-height:
normal;font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    cccdlflags='-fPIC', lddlflags='-shared -O2 -L/usr/local/lib
-fstack-protector'</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255); min-height: 16px;"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass=""></b></span><br class="" /></div><div class="" style="margin: 0px; font-size: 14px;
line-height:normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255); min-height: 16px;"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class=""></b></span><br class="" /></div><div class=""
style="margin:0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255,
255);"><spanclass="" style="font-variant-ligatures: no-common-ligatures"><b class="">Characteristics of this binary
(fromlibperl): </b></span></div><div class="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">  Compile-time options: HAS_TIMES PERLIO_LAYERS PERL_COPY_ON_WRITE</b></span></div><div
class=""style="margin: 0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color:
rgb(255,255, 255);"><span class="" style="font-variant-ligatures: no-common-ligatures"><b class="">                   
   PERL_DONT_CREATE_GVSV</b></span></div><div class="" style="margin: 0px; font-size: 14px; line-height: normal;
font-family:'Courier New'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">                        PERL_HASH_FUNC_ONE_AT_A_TIME_HARD
PERL_MALLOC_WRAP</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">                        PERL_PRESERVE_IVUV USE_64_BIT_ALL
USE_64_BIT_INT</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">                        USE_LARGE_FILES USE_LOCALE
USE_LOCALE_COLLATE</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">                        USE_LOCALE_CTYPE USE_LOCALE_NUMERIC
USE_LOCALE_TIME</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family:
'CourierNew'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">                        USE_PERLIO USE_PERL_ATOF</b></span></div><div class=""
style="margin:0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255,
255);"><spanclass="" style="font-variant-ligatures: no-common-ligatures"><b class="">  Built under
linux</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height: normal; font-family: 'Courier
New';background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures: no-common-ligatures"><b
class=""> Compiled at Dec  7 2016 04:18:40</b></span></div><div class="" style="margin: 0px; font-size: 14px;
line-height:normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">  @INC:</b></span></div><div class="" style="margin:
0px;font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span
class=""style="font-variant-ligatures: no-common-ligatures"><b class="">   
/usr/local/lib/perl5/site_perl/5.24.0/x86_64-linux</b></span></div><divclass="" style="margin: 0px; font-size: 14px;
line-height:normal; font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">   
/usr/local/lib/perl5/site_perl/5.24.0</b></span></div><divclass="" style="margin: 0px; font-size: 14px; line-height:
normal;font-family: 'Courier New'; background-color: rgb(255, 255, 255);"><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass="">    /usr/local/lib/perl5/5.24.0/x86_64-linux</b></span></div><div class=""
style="margin:0px; font-size: 14px; line-height: normal; font-family: 'Courier New'; background-color: rgb(255, 255,
255);"><spanclass="" style="font-variant-ligatures: no-common-ligatures"><b class="">   
/usr/local/lib/perl5/5.24.0</b></span></div><divclass=""><span class="" style="font-variant-ligatures:
no-common-ligatures"><bclass=""><br class="" /></b></span></div><div class=""><span class=""
style="font-variant-ligatures:no-common-ligatures"><b class="">Thank you,</b></span></div></span></div><div
class=""><spanclass="Apple-style-span" style="border-collapse: separate; font-family: Helvetica;
font-variant-ligatures:normal; font-variant-position: normal; font-variant-numeric: normal; font-variant-alternates:
normal;font-variant-east-asian: normal; line-height: normal; border-spacing: 0px;"><span class="Apple-style-span"
style="border-collapse:separate; color: rgb(0, 0, 0); font-family: Helvetica;  font-style: normal; font-variant:
normal;font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform:
none;white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px;
-webkit-border-vertical-spacing:0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto;
-webkit-text-stroke-width:0px; "><div class="" style="word-wrap: break-word; -webkit-nbsp-mode: space;
-webkit-line-break:after-white-space; "><div class="">Bob Nick</div><div class=""><a class=""
href="mailto:bnick@keyweb.com">bnick@keyweb.com</a></div><divclass=""><a class=""
href="http://www.keyweb.com">www.keyweb.com</a></div></div></span><brclass="Apple-interchange-newline" /></span><br
class="Apple-interchange-newline"/></div><br class="" /></div>