Search · Index

Popular tags

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

No registered users in community xowiki
in last 30 minutes

Contributors

OpenACS.org

Postgres 8.x (e.g. 8.1.* and 8.2.*) 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:openacs-system-install-freebsd-ports, en:postgresql-install
Categories: Subsystems Documentation (OpenACS.org)

Comments

Add a comment

Install Postgres 8.1.x and 8.2.x

Popular tags

No registered users in community xowikiin last 30 minutes

OpenACS.org

No registered users in community xowiki
in last 30 minutes