Forum OpenACS Q&A: Re: setting up a second OpenAcs instace - problem loading nspostgres.so
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