Mapscript is looking for libpq.3 instead of libpq.4

[tmelhuish@…]

I just installed postgresql 8.1.2 and Postgis 1.1.1. I completely deleted my
/usr/local/pgsql directory prior to installing postgresql 8.1.2 and only
/usr/local/pgsql/lib/libpq.so.4 was build. No libpq.so.3 was built like in
postgresql 7.X. I tried both mapserver 4.4.2 and 4.6.2 which give me the
following error message in the httpd error_log when trying to run mapscript in perl:

Can't load
'/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/mapscript/mapscript.so'
for
module mapscript: libpq.so.3: cannot open shared object file: No such file or
directory at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
[Wed Feb 01 18:11:00 2006] [error] [client 192.168.119.112]  at
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/mapscript.pm line 7

When I look at what is libraries that are required for mapserv I see libpq.3 is
trying to be loaded:
[root@WIRH90 mapserver-4.6.2]# ldd mapserv
        libgd.so.2 => /usr/local/lib/libgd.so.2 (0x4002a000)
        libjpeg.so.62 => /usr/local/lib/libjpeg.so.62 (0x40062000)
        libfreetype.so.6 => /usr/lib/libfreetype.so.6 (0x4007f000)
        libpng12.so.0 => /usr/lib/libpng12.so.0 (0x400d0000)
        libz.so.1 => /usr/lib/libz.so.1 (0x400f3000)
        libpdf.so.1 => /usr/local/lib/libpdf.so.1 (0x40101000)
        libproj.so.0 => /usr/local/lib/libproj.so.0 (0x40190000)
        libgdal.1.1.so => /usr/local/lib/libgdal.1.1.so (0x401c4000)
        libpq.so.4 => /usr/local/pgsql/lib/libpq.so.4 (0x40467000)
        libcurl.so.2 => /usr/local/lib/libcurl.so.2 (0x4047e000)
        libssl.so.4 => /lib/libssl.so.4 (0x404a7000)
        libcrypto.so.4 => /lib/libcrypto.so.4 (0x404dc000)
        libdl.so.2 => /lib/libdl.so.2 (0x405ce000)
        libgssapi_krb5.so.2 => /usr/kerberos/lib/libgssapi_krb5.so.2 (0x405d2000)
        libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x405e5000)
        libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3 (0x40643000)
        libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3 (0x40645000)
        libresolv.so.2 => /lib/libresolv.so.2 (0x40655000)
        libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
        libm.so.6 => /lib/tls/libm.so.6 (0x40668000)
        libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x4068a000)
        libpthread.so.0 => /lib/tls/libpthread.so.0 (0x4073d000)
        libXpm.so.4 => /usr/X11R6/lib/libXpm.so.4 (0x4074b000)
        libX11.so.6 => /usr/X11R6/lib/libX11.so.6 (0x4075a000)
        libpq.so.3 => not found
        libclntsh.so.9.0 => /usr/local/lib/libclntsh.so.9.0 (0x4083a000)
        libungif.so.4 => /usr/lib/libungif.so.4 (0x41147000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x4114f000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x41157000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x41185000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
        libXext.so.6 => /usr/X11R6/lib/libXext.so.6 (0x4119a000)
        libwtc9.so => /oracle/9.2.0/lib/libwtc9.so (0x411a8000)

I copied over the libpq.3 from a server I had running postgresql 7.4 and
Mapserver started up but now I get erroneous error probibly because the shared
objects are not compatable.  

Please let me know if you need any other information to help determine the problem.

Thanks - Tom

[sdlime]

Tom: I'm not sure that this is a bug as much as a configuration issue. Have you 
taken the problem to the mailing list? If not then that's the place to start.

Steve