Page 1 of 1

postgres upgrade howto ?

Posted: Tue Nov 11, 2008 3:47 am
by frankseu
Hallo,

i am running debian etch.
During my scalix upgrade from 11.3 to 11.4.2 i also got the newest version of the postgres db installed (8.1). Can anyone tell me how to migrate from the still installed and used postgres version 7.x to 8.1 ?

regards
Frank

Posted: Tue Nov 11, 2008 8:18 am
by charon
i could not solve this when i changed from openSUSE to CentOS.

i ended up with backing up with my backup script into mbxo format, install CentOS and then import the backed up data

Posted: Wed Nov 12, 2008 2:31 am
by Valerion
Postgres changes things during upgrades, requiring you to re-initialize the DB. The Scalix Postgres DB doesn't contain anything important, everything can be regenerated on the fly, so you can uninstall the Scalix DB component, delete the DB, upgrade your Postgres and re-install the Scalix DB. SWA logins will be slow the first time each user logs in, but that should be the only effect.