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:


This script executes yum install postgresql (and related RPMs).

Comments are closed.