Forum OpenACS Q&A: Postgres 7.3.x versus 7.4.x

Collapse
Posted by Jon Rowell on
The installation docs for openacs 5.2 claims it can be used with postgres 7.3.[234] or 7.4.x.

If I dump the db from 7.4.6 and try to import into 7.3.x I get sql errors. Is there something in the installation that decides what kind of sql to use and that is what is hanging me up?

I am wanting to use 7.3.x because of some performance issues I am having with using 7.4.x or 8.0.x. Anything greater than 7.3.x is exponentially slower.

I can explain more about my situation if needed but I am hoping that someone can at least tell me that they have had similar issues and they had to change *something* with 7.4.x in order to make it work somewhere near the speed of 7.3.x.

Jon Rowell

Collapse
Posted by Andrew Dunstan on
1. Postgres doesn't provide any way of downgrading, although it has extensive support in pg_dump for upgrading.

2. The slony replication system has been used to downgrade. And it supports postgresql back to version 7.3.x. See http://gborg.postgresql.org/project/slony1/projdisplay.php

3. Have you asked in the postgres mailing lists about your performance issues? There is a list just on performance, as well as the hackers list where all the postgres developers hang out. See http://www.postgresql.org/community/lists/