Re: error while executing a c program with embedded sql

<radha(dot)manohar(at)ndsu(dot)nodak(dot)edu> writes:
> ./test1: error while loading shared libraries: libecpg.so.3: cannot open
> shared object file: No such file or directory

The dynamic linker is failing to find either libecpg.so itself, or one
of the shared libraries it depends on (perhaps libpq.so).

If you are on a Linux system you probably want to fix your ldconfig
configuration so that all these libraries are found automatically.
You can run ldd on a particular executable or shared library to see what
libraries it references and whether those libraries are getting found
in the proper places.

Note that it is entirely possible for the program linking stage to
succeed but dynamic linking to fail at runtime. For various reasons the
search rules are not quite the same in the two contexts ...

regards, tom lane