Forum OpenACS Development: Postgres releases for OpenACS

Collapse
1: Postgres releases for OpenACS
Posted by Jose Agustin Lopez Bueno on 11/11/09 06:13 PM
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
2: Re: Postgres releases for OpenACS (response to 1)
Posted by Gustaf Neumann on 11/11/09 07:32 PM
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
3: Re: Postgres releases for OpenACS (response to 2)
Posted by Jose Agustin Lopez Bueno on 11/13/09 06:29 PM
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
4: Re: Postgres releases for OpenACS (response to 3)
Posted by Gustaf Neumann on 11/13/09 08:36 PM
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
5: Re: Postgres releases for OpenACS (response to 3)
Posted by Dave Bauer on 11/16/09 03:32 AM
If you can't figure this out please post the specific error messages so we can help you more.