Sandeep Joshi <sjoshi@Zambeel.com> writes:
> It results in following error: (just "shared")
> ERROR: Load of file /var/lib/pgsql/trigger/db1trig.so failed: libpq.so.2.1:
> cannot open shared object file: No such file or directory
> I tried following link line (which specifies "run-time" linking path).
> ld -shared -o db1trig.so db1trig.o -R/work/posgresql/lib -lpq
> This results in following error when "PQsetdb" is called:
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.
It looks like you're down to debugging vagaries of the dynamic linker
on your platform :-(. You might find that the linker sends useful
error messages to stderr --- check the postmaster's logfile. (If you're
not redirecting the postmaster's stdout/stderr into a logfile, do so.
Don't forget to NOT use -S, or the logfile will never get any output.)
regards, tom lane