zhong ming wu wrote:
... This machine is RHEL 5.5 and has both RH stock postgres 8.1.18 in standard location as well as pg 8.4.4 which is in my home folder. The libraries are libpg.so.4 and libpg.so.5 respectively for two versions. I just lifted one of the examples from postgres documentation and if I just use stock 8.1.18 compiling is ok and the final program runs to completion as expected. But if I compile the same program with 8.4.4 the compiled program dies with "error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or dire ctory" Does the error mean that the program can't locate this libpq.so.5? That symlink is good but in ~/local/lib and points to libpq.so.5.2 in there. It's not in the standard folder like /usr/lib. I tried to symlink to the working folder but no go.
you probably need to either use "-R $HOME/local/lib" on the link command to specify the runtime path to find .so's in, or add $HOME/local/lib to LD_LIBRARY_PATH (I prefer the former if the linking is under my control, but revert to the latter if I absolutely have to)
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
