Forum OpenACS Q&A: Re: PostgreSQL vs Oracle

Collapse
7: Re: PostgreSQL vs Oracle (response to 1)
Posted by Malte Sussdorff on
OpenACS 4.6 does not support PostgreSQL 8 (to my knowledge) as some names in procedures had to be changed for it to work on 5.2. But the knowledge what has to be changed is in the community, so you might just as well as when you do the upgrade. But yes, definitely upgrade to 5.1 (or even 5.2, depending on when you want to switch).

University of Vienna is running on PostgreSQL and they are happy with it, serving up to 1000 users at a time (if I remember the statistics correctly), without clustering.

The technical side apart there is growing consent that supporting two databases officially is already delaying our release cycles. Therefore I'm pretty sure we will not add any other database to the officially supported list. If someone wants to maintain a port though, he is most definitely welcome to do so.