Installing or Updating PostgreSQL on Your cPanel & WHM Server
For cPanel & WHM version 11.30
Installing and updating PostgreSQL is not a difficult process, but you should follow the steps below in order to ensure that everything is properly configured.
cPanel & WHM works with PostgreSQL 7.3.x or later. Earlier versions will not work with cPanel & WHM.
- 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).
- On a FreeBSD system, you can use
ports to install PostgreSQL.
- You may also execute the following commands to install PostgreSQL on a FreeBSD system:
/scripts/installpkg postgresql-server postgresql-client
echo postgresql_enable="YES" >> /etc/rc.conf
/scripts/makecpphp (freebsd 5.x+ only)
- In your web browser, log into WHM.
- Select Postgres Config in the SQL Services section of WHM.
- 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 you are installing PostgreSQL for the first time, click the Install Config button.
- Warning: If you have an existing PostgreSQL configuration, this will overwrite your configuration authentication file (
- If you are upgrading from PostgreSQL 7.2.x or earlier, restore the SQL dump you created in step 3 by using
psql or some other method.
- PostgreSQL is now accessible from your cPanel interface.
For more information about PostgreSQL, visit the PostgreSQL website
cPanel, Inc. does not
supply PostgreSQL, nor do we not provide RPMs to update PostgreSQL to the latest version.
Topic revision: r13 - 31 Jan 2011 - 12:53:06 - MelanieSeibert