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.