Martijn van Oosterhout wrote:
Can you provide the output of ldd? The libraries are supposed to be
reasonably compatable.
web server:
linux-gate.so.1 => (0x00ab0000)
libexpat.so.0 => /usr/lib/libexpat.so.0 (0x00411000)
libpq.so.4 => /usr/lib/libpq.so.4 (0x00324000)
libssl.so.5 => /lib/libssl.so.5 (0x005c2000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x0069c000)
libm.so.6 => /lib/libm.so.6 (0x0049e000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00bd7000)
libc.so.6 => /lib/libc.so.6 (0x00d82000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00ece000)
libcrypto.so.5 => /lib/libcrypto.so.5 (0x00c00000)
libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00afc000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00111000)
libresolv.so.2 => /lib/libresolv.so.2 (0x00f0c000)
libnsl.so.1 => /lib/libnsl.so.1 (0x00f88000)
libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x00b70000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0x00a9f000)
libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00ad6000)
libdl.so.2 => /lib/libdl.so.2 (0x0013f000)
libz.so.1 => /usr/lib/libz.so.1 (0x003fc000)
/lib/ld-linux.so.2 (0x00267000)
libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x00ac3000)
dev server:
linux-gate.so.1 => (0x00497000)
libexpat.so.0 => /usr/lib/libexpat.so.0 (0x0065b000)
libpq.so.4 => /usr/lib/libpq.so.4 (0x00524000)
libssl.so.5 => /lib/libssl.so.5 (0x00210000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00775000)
libm.so.6 => /lib/libm.so.6 (0x002b7000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x006de000)
libc.so.6 => /lib/libc.so.6 (0x00bff000)
libcrypto.so.5 => /lib/libcrypto.so.5 (0x00101000)
libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00d74000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x009b6000)
libresolv.so.2 => /lib/libresolv.so.2 (0x00395000)
libnsl.so.1 => /lib/libnsl.so.1 (0x00248000)
libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x0025d000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0x00d44000)
libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00d49000)
libdl.so.2 => /lib/libdl.so.2 (0x00275000)
libz.so.1 => /usr/lib/libz.so.1 (0x004e1000)
/lib/ld-linux.so.2 (0x00a8b000)
libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x00d6f000)
In any case, you should try to run both servers against the same set of
libs and headers. You can have multiple copies of libpq around and
select it at compile time. The client library doesn't really have to
match the server version...
As I asked in another thread: Does it work to install the
postgresql-server RPM from the 8.1 version and the others from the
Fedora 4 included 8.0 version?
--
Bryan White, ArcaMax Publishing Inc.
