Thread: libpq.so.3 not found error while use Perl DBI

libpq.so.3 not found error while use Perl DBI

From
jake@omnimode.com (jake johnson)
Date:
I'm using Postgresql 7.3.4, FreeBSD 4.7, & Apache 2.0.47.  I have a
perl script which uses the DBI module and it works great from the
command line as long as I have '/usr/local/pgsgl/lib' in
LD_LIBRARY_PATH or else it would give me an 'libpq.so.3 not found'
error.

Now, I've turned that perl script into a cgi and from the apache error
log I see the 'libpq.so.3 not found' message.  My own user's
LD_LIBRARY_PATH is set correctly of course but could it be because the
apache user's LD_LIBRARY_PATH isn't set properly that this is
occurring?  I believe I've used the ldconfig and other tools to set
the library path but I'm not getting anywhere.  Can anyone help?

- Jake