I am trying to compile and run c program which reads the journal of an
ancient propriety database
and copy these transactions over to postgres. The process I follow is
by trial and error and made worse
by the fact that I haven't before made c program which talks to
postgres and because I have to use
some c pre-processor and linker required by that other database.
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.
I configured 8.4.4 with "--enable-shared" even though I think this is
unnecessary; is that right?
Thanks for any advice you can give