Forum OpenACS Development: Postgres releases for OpenACS

Hello!

The new Postgres releases (8.3.x and 8.4.x) have many improvements for hot backups and other tools.

Anybody are running OpenACS with PG releases greater
than 8.2.x?

Regards,
Agustin

Collapse
Posted by Gustaf Neumann on
PostgreSQL 8.3 is in the compatibility matrix, https://openacs.org/xowiki/openacs-compatibility-matrix, PostgreSQL 8.4 works at least with head (most likely with OpenACS 5.5). We use 8.3 in production since more than a year, and on openacs.org as well since the move to vienna.
Collapse
Posted by Jose Agustin Lopez Bueno on
Hi Gustaf!

Do you use tsearch?

We are trying upgrade from 8.2 dump to 8.3
but we have several errors with tsearch
functions.

Agustin

Collapse
Posted by Gustaf Neumann on
yes, we use tsearch (as well on openacs.org). The only thing i remember from openacs.org (done in Feb) was

ERROR: text search configuration "default" does not exist

The following command fixed it:

CREATE TEXT SEARCH CONFIGURATION public.default ( COPY = pg_catalog.english );

-gustaf neumann

Collapse
Posted by Dave Bauer on
If you can't figure this out please post the specific error messages so we can help you more.