Forum OpenACS Q&A: Re: setting up a second OpenAcs instace - problem loading nspostgres.so
Where is libpq.so.5 located in your system?
What are the permission on the shared lib and its path?
Under which user runs your nsd?
[root@vps ~]# ls -al /usr/local/pgsql
drwxr-xr-x 3 postgres web 2048 May 17 01:11 lib
lrwxrwxrwx 1 postgres web 12 May 17 01:11 libpq.so -> libpq.so.5.1
lrwxrwxrwx 1 postgres web 12 May 17 01:11 libpq.so.5 -> libpq.so.5.1
-rwxr-xr-x 1 postgres web 111295 May 17 01:11 libpq.so.5.1
nsd is run in both situations by the same user who is member of the web group
We had a few years ago the problem, that psql worked perfectly, but aolserver was not able to load nspostgres. The problem were default permissions on the system that were used during the make install.... since aolserver switches to the specified user+group before loading the .so files, things went wrong withing aolserver. Sounds suspiciously like what you are seeing.
there was a mistake in the run script in daemontools. Indeed the issue was $LD_LIBRARY_PATH not being set.
thank you both for your help