Forum OpenACS Q&A: Response to cant get postgres.so driver to work !!!!

Collapse
Posted by Ben Adida on
This is not so mysterious actually, and is exactly the same issue that Oracle people have: your system has to know where to find the shared libraries of the Postgres driver. I recommend *against* making copies or symlinks in your /usr/lib directory, which will crowd things in there.

Instead, you should set things up so that the library load path will find the libpq stuff. If you're under Linux, the recommended way of doing this is to edit your /etc/ld.so.conf file and add /usr/local/pgsql/lib to it, then to run /sbin/ldconfig (all as root). Otherwise, you will need to wrap your nsd in a shell script that sets the LD_LIBRARY_PATH correctly.