Install or Update PostgreSQL on Your cPanel & WHM Server

For cPanel & WHM version 11.38

It is not difficult to install or update Postgre SQL on your server. However, we strongly recommend that you have an experienced PostgreSQL database administrator perform this process.

Note: cPanel & WHM works with PostgreSQL version 7.3.x or later. Earlier versions of PostgreSQL will not work with cPanel & WHM.

To configure PostgreSQL on your server, perform the steps below as the root user.

1. If you currently have PostgreSQL version 7.2.x, use a method such as pg_dumpall to back up your databases.
2. Move any PostgreSQL data directories that you wish to keep into another location with the following command: mv /var/lib/pgsql /var/lib/pgsql.old
3. To begin the installation process on a CentOS or RedHat system, run this script: /scripts/installpostgres. This script executes yum install postgresql (and related RPMs).
4. IN WHM, navigate to ( Home >> SQL Services >> Postgres Config ).
5. Type a new PostgreSQL password in the text box and click Change Password.
   • Warning: Only use letters and numbers. Non-alphanumeric characters cause problems.
6. If this is your first time to install PostgreSQL, click the Install Config button.
   • Warning: If you already have a PostgreSQL configuration, this will overwrite your configuration authentication file ( pg_hba.conf).
7. If you upgraded from PostgreSQL version 7.2.x or earlier, restore the SQL dump that you created in step 3 with the =psql=command or an appropriate alternate method.

PostgreSQL is now accessible from your cPanel interface.

Note: For more information about PostgreSQL, visit the PostgreSQL website.

Important: cPanel, Inc. does not supply PostgreSQL or provide RPMs to update PostgreSQL to the latest version.