Re: DBD::Pg 2.10.7 compile failed on RH4

<Tapio(dot)Niva(at)tietoenator(dot)com> writes:
> we have 32-bit PostgreSQL version 8.3.4 on 64-bit RHEL4 , Postgres
> itself is working as expected.
> ...
> Our problem is that DBD::Pg version 2.10.7 will not compile ,

> 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

What it looks like to me is that you've got a 64-bit perl build ("file"
on the perl executable would be a good way to confirm that). If so,
you're going to need a 64-bit version of libpq.so to link into it.

There's no reason a 64-bit libpq wouldn't interoperate with a 32-bit
server, so just installing the 64-bit postgresql-libs RPM alongside what
you have ought to be sufficient.

regards, tom lane