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

Collapse
1: Postgres 7.3.x versus 7.4.x
Posted by Jon Rowell on 05/14/05 08:21 AM
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
2: Re: Postgres 7.3.x versus 7.4.x (response to 1)
Posted by Andrew Dunstan on 05/15/05 11:07 PM
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/