Downgrading Postgres - H-Sphere Sysadmin Guide - Positive Software Corporation

H-Sphere Sysadmin Guide

Downgrading Postgres

H-Sphere works correctly only with Postgres 7.x. Thus, if you have accidentally upgraded Postgres package on your CP server to version 8.x and higher, you need to perform its downgrade to the version you had.

Log into the control panel server as root.
Back up CP postgres home dir.
Back up the file /etc/init.d/postgresql.
Stop the control panel.
Stop Postgres:
/etc/rc.d/init.d/postgresql stop
Uninstall Postgres:
rpm -qa | grep postgres rpm -e postgres rpm -e --nodeps
Install the original version of postgresql-libs, then postgres. The installations are available on your control panel server in the directory /hsphere/install/pkg/<CP_OS>/
Start Postgres:
/etc/rc.d/init.d/postgresql start
Start the control panel.