Search · Index

Popular tags

ad_form (1), ADP (1), ajax (1), aolserver (1), asynchronous (2), bgdelivery (3), bugtracker (1), COMET (1), cvs (4), debian (6), emacs (2), FreeBSD (1), includelets (2), install (2), installation (1), installers (1), javascript (2), libthread (3), linux (3), monitoring (1), nginx (1), oracle (1), osx (2), patches (1), performance (2), postgres (4), pound (1), redhat (1), selenium (1), ssl (1)

No registered users in community xowiki
in last 30 minutes

Contributors

OpenACS.org

Postgres 8.1.x and later versions

Postgres 8.x (e.g. 8.1.* and later) require a few changes in the configuration file for backward compatibility:

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;

Exit psql:

\q

This is the original thread

For a full script on how to install PG 8.2 with ltree and tsearch2 look at Malte's install script

References to this Page: en:OpenACSInstallGuide, en:postgresql-install, en:openacs-system-install-freebsd-ports Categories: Subsystems Documentation (OpenACS.org)