Installing or Updating PostgreSQL on Your cPanel & WHM Server
cPanel & WHM works with PostgreSQL 7.3.x or later.
Using the command line interface, log into your server as root.
If you have PostgreSQL 7.2.x installed, back up your databases using pg_dumpall or some other method. If you have databases you wish to keep, move your existing PostgreSQL data directory somewhere else by, for example, typing the following command.
mv /var/lib/pgsql /var/lib/pgsql.old
To begin the installation process:
On a CentOS or RedHat system, use the following script:
/scripts/installpostgres
This script executes yum install postgresql (and related RPMs).