I solved this problem halfway through posting - this is for the
archives in case someone else has the same problem.
After installation, I could work in ACS for a limited period of time,
then some database access will produce a log entry like this and
AOLServer would hang. I could kill it (and init respawned it) and
then all would be well for a while longer. I was using versions:
AOLServer 3.2, nspostgres.so 3.0 OpenACS 3.2.4 and Postgres 7.0.2.
[26/Oct/2000:14:40:28][1965.8196][-conn0-] Notice: dbdrv: opening
database 'postgres:localhost::acstest'
[26/Oct/2000:14:40:28][1965.8196][-conn0-] Notice: nspostgres: opening
'acstest' on 'localhost'
[26/Oct/2000:14:40:28][1965.8196][-conn0-] Notice: nspostgres: opened
connection to 'localhost::acstest'
[26/Oct/2000:14:40:29][1965.8196][-conn0-] Notice: dbinit:
sql(localhost::acstest): '
select user_id, token, secure_token,
last_ip, last_hit from sec_sessions
where session_id = 2
'
[26/Oct/2000:14:40:29][1965.8196][-conn0-] Notice: dbinit:
sql(localhost::acstest): 'select ad_group_member_p(1,
system_administrator_group_id()) from dual'
[26/Oct/2000:14:40:30][1965.8196][-conn0-] Error:
Solution: use the postgres driver from OpenACS, not the one
from AOLServer. ln -s postgres.so nspostgres.so to avoid having to
change the config files. Not sure why this works.