help with pgsql_perl5-1.9.0
От | Bob Nick |
---|---|
Тема | help with pgsql_perl5-1.9.0 |
Дата | |
Msg-id | 5772C3C8-8767-497B-9B25-F5668272F526@keyweb.com обсуждение исходный текст |
Список | 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>
В списке pgsql-interfaces по дате отправления:
Следующее
От: DevartДата:
Сообщение: [INTERFACES] Support for PostgreSQL 9.5 and 9.6 in dbForge Data Compare forPostgreSQL