Forum OpenACS Q&A: Recommended version of PostgreSQL?

Collapse
1: Recommended version of PostgreSQL?
Posted by Andrew Piskorski on 01/24/23 07:45 PM
I see that PostgreSQL is currently up to version 15.1, and they consider versions 15, 14, 13, 12, and 11 to still be "supported". Which versions does OpenACS currently support or recommend? Any known problems with the latest versions, either with OpenACS specifically, or just for general database use?
Collapse
2: Re: Recommended version of PostgreSQL? (response to 1)
Posted by Gustaf Neumann on 01/24/23 08:18 PM
For new installs, use PostgreSQL 15.

If you upgrade from ancient versions of OpenACS, you might have to use some versions in-between, since newer versions of PostgreSQL have dropped some long deprecated functions, which might be used in old upgrade scripts.

OpenACS 5.10.0 requires at least PostgreSQL 9.6 (https://openacs.org/xowiki/openacs-todo), but was tested for it release with PostgreSQL 13 (the newest version of PostgreSQL available at the time of the release), but works as well with all newer versions.

openacs.org runs currently with PostgreSQL 13.

Collapse
3: Re: Recommended version of PostgreSQL? (response to 1)
Posted by Antonio Pisano on 02/09/23 01:01 PM
When upgrading OpenACS versions <= 5.8, one should use a Postgres 8.* (e.g. latest Postgres 8.4)

One should then dump the resulting 5.8 database, restore on a later Postgres version (any supported version, such as the one from your distro package manager should be fine) and proceed with the upgrade to 5.10.*

I just had experience about such an upgrade from an old OpenACS 5.4.* to 5.10.*, which was successfull (save the expected fallouts and adjustments).