Forum OpenACS Q&A: Re: Should Keepalive be enabled in config.tcl?

it sure looks like a broken pg install to me. In particular it seems to me like this could only be an internal pg problem...

psql:acs-reference-create.sql:16: WARNING:  Error occurred while executing PL/p\gSQL function acs_priv_hier_ins_del_tr
psql:acs-reference-create.sql:16: WARNING:  line 61 at SQL statement
psql:acs-reference-create.sql:16: ERROR:  cache lookup failed for opclass 2003

acs_priv_hier_ins_del_tr has not changed since May.

Also this looks quite suspicious as well:

Error: apm_package_install: Error installing Reference Data - Timezone version 5.0.0a5:
psql:/tmp/psql-copyfile-PYr4ra:1: ERROR:  GetTypeElement: Cache lookup of type 23 failed
psql:/tmp/psql-copyfile-PYr4ra:1: lost synchronization with server, resetting connection
                                                                                

since this is just issuing sql commands fed in by psql.