Hello,
we have 32-bit PostgreSQL version 8.3.4 on 64-bit RHEL4 , Postgres
itself is working as expected.
We are using PostreSQL via following perl version
............................................
# perl -v
This is perl, v5.10.0 built for i686-linux-thread-multi
(with 4 registered patches, see perl -V for more detail)
Copyright 1987-2007, Larry Wall
Binary build 1004 [287188] provided by ActiveState
http://www.ActiveState.com
Built Sep 3 2008 11:22:08
............................................
Our problem is that DBD::Pg version 2.10.7 will not compile ,
/usr/bin/ld skips all libpq files as incompatible - please see a slice
of the result below :
............................................
rm -f blib/arch/auto/DBD/Pg/Pg.so
LD_RUN_PATH="/usr/lib" gcc -shared -O2 Pg.o dbdimp.o quote.o types.o
-o blib/arch/auto/DBD/Pg/Pg.so \
-L/usr/lib -lpq -lm \
/usr/bin/ld: skipping incompatible /usr/lib/libpq.so when searching for
-lpq
/usr/bin/ld: skipping incompatible /usr/lib/libpq.a when searching for
-lpq
/usr/bin/ld: skipping incompatible
/usr/lib/gcc/x86_64-redhat-linux/3.4.6/../../../libpq.so when searching
for -lpq
/usr/bin/ld: skipping incompatible
/usr/lib/gcc/x86_64-redhat-linux/3.4.6/../../../libpq.a when searching
for -lpq
/usr/bin/ld: skipping incompatible /usr/lib/libpq.so when searching for
-lpq
/usr/bin/ld: skipping incompatible /usr/lib/libpq.a when searching for
-lpq
/usr/bin/ld: cannot find -lpq
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/Pg/Pg.so] Error 1
............................................
libpq files available ( actually there seems to be only 1
file=/usr/lib/libpq.so.5.1 with 2 links to it ) are as below :
............................................
# find / -name libpq.so*
/usr/lib/libpq.so.5.1
/usr/lib/libpq.so
/usr/lib/libpq.so.5
# ll /usr/lib/libpq.so.5.1
-rwxr-xr-x 1 root root 122616 Sep 20 18:52 /usr/lib/libpq.so.5.1
# ll /usr/lib/libpq.so
lrwxrwxrwx 1 root root 12 Oct 6 14:06 /usr/lib/libpq.so ->
libpq.so.5.1
# ll /usr/lib/libpq.so.5
lrwxrwxrwx 1 root root 12 Oct 6 14:05 /usr/lib/libpq.so.5 ->
libpq.so.5.1
# file /usr/lib/libpq.so.5.1
/usr/lib/libpq.so.5.1: ELF 32-bit LSB shared object, Intel 80386,
version 1 (SYSV), stripped
#
............................................
I assume that something is mixed here (=32/64-bit) because linker claims
for incompatibility - but because there is only 1 libpq created by
Postgres install, I'm a bit lost.
Should we use some other linker version ?
Any ideas how to proceed ?
Best Regards,
Tapio