Forum OpenACS Q&A: pgsql problem

Collapse
1: pgsql problem
Posted by Budi Wiyono on 10/05/00 01:19 PM
Hi All,

I'm using PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-
2.91.66
But my OpenACS installation not working 100% yet.
How to fix that problem ? Should i modify some tcl code
from standard distribution ?

Here is the error message:

[05/Oct/2000:17:53:22][6054.3076][-conn0-] Error: Ns_PgExec: result
status: 7 message: ERROR:  stat failed on
file '/usr/local/pgsql/lib/plpgsql.so': No such file or directory

Regards,
BDW

Collapse
2: Response to pgsql problem (response to 1)
Posted by Dan Wickstrom on 10/05/00 03:24 PM
Does the plpgsql.so library file exist and is it readable by the aolserver process?
Collapse
3: Response to pgsql problem (response to 1)
Posted by Lachlan Myers on 10/06/00 01:41 AM
Check the responses to this question "aolserver loading postgres.so driver" (search on this string is easiest).

If you are using binaries from RPMs they use a different location for the library files.