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.

1. Log into the control panel server as root.
2. Back up CP postgres home dir.
3. Back up the file /etc/init.d/postgresql.
4. Stop the control panel.
5. Stop Postgres:
   /etc/rc.d/init.d/postgresql stop
6. Uninstall Postgres:
   rpm -qa | grep postgres
   rpm -e postgres
   rpm -e --nodeps
7. 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>/
8. Start Postgres:
   /etc/rc.d/init.d/postgresql start
9. Start the control panel.