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.
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
- If you currently have PostgreSQL version 7.2.x, use a method such as
pg_dumpall to back up your databases.
- 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
- 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).
- IN WHM, navigate to ( Home >> SQL Services >> Postgres Config ).
- Type a new PostgreSQL password in the text box and click Change Password.
- Warning: Only use letters and numbers. Non-alphanumeric characters cause problems.
- 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 (
- 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.
For more information about PostgreSQL, visit the PostgreSQL website
cPanel, Inc. does not
supply PostgreSQL or provide RPMs to update PostgreSQL to the latest version.
Topic revision: r17 - 19 Apr 2013 - 20:18:17 - Main.JenniferDoubrava