Postgres 8.1.x to 9.1
PostgreSQL 8.x (e.g. 8.1.* and later up to 9.1) require a few changes in the configuration file for backward compatibility (see below).
Note that OpenACS 5.8 or newer works with PostgreSQL 9.1 (or newer) out of the box, the special configurations for postgresql.conf described below are not needed anymore.
1. Configure postgres8 with all compatibility ON in postgresql.conf:
add_missing_from = on regex_flavor = extended default_with_oids = on
2. If you are upgrading an OpenACS site between versions 4.5.2 to 5.2 and not continuing to 5.3, then: After the createdb step to create the OpenACS database, generate the next function before you import the pre-existing OpenACS database.
From your shell prompt enter:psql <dbname>
From the psql prompt enter the follow plpgsql code to create the bitfromint4 function:
create or replace function bitfromint4 (integer) returns bit varying as ' begin return $1::bit(32); end;' language 'plpgsql' immutable strict;
For a full script on how to install PG 8.2 with ltree and tsearch2 look at Malte's install script