Check installed version and module
rpm -qa|grep postgres
buckup your old /var/lib/pgsql folder
mv /var/lib/pgsql /var/lib/pgsql.old
Uninstall / Remove Postgre and it's module
rpm -e rh-postgresql-server-7.3.6-7
rpm -e rh-postgresql-7.3.6-7
rpm -e rh-postgresql-devel-7.3.6-7
rpm -e rh-postgresql-python-7.3.6-1
rpm -e rh-postgresql-libs-7.3.6-7
Make sure completely removed. Shouldn't have any result with this command.
rpm -qa|grep postgres
if you see that this rpm is neede by perl-DBD-Pg-1.21-2 you must do the following
rpm -qa|grep perl-DBD
Result fromcommand above should be
perl-DBD-MySQL-2.1021-3
perl-DBD-Pg-1.21-2
So you have to uninstall perl package
rpm -e perl-DBD-Pg-1.21-2
rpm -e rh-postgresql-libs-7.3.6-7
/scripts/installpostgres
y [enter]
Login to WHM
Go to SQL Services
Postgres Config
Install Config
Then again Click on Postgres Config in Service Configuration
Type your password and click Change Password
service postgre restart
service chkservd restart
