Installing PostgreSQL on cPanel Server

Installing PostgreSQL is not a difficult process, but you should follow the steps below in order to ensure that everything is properly configured.

Note: cPanel requires PostgreSQL 7.3.x or later. Earlier versions will not work.

1. If necessary, update to cPanel to latest version. You can update cPanel by typing /scripts/upcp from the command line while logged in as root.
2. SSH to your server as root.
3. If you have PostgreSQL 7.2.x installed, back up your databases using pg_dumpall or some other method. If you do not 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
4. Type the following command:
   • /scripts/installpostgres
5. From your web browser, log into WebHost Manager.
6. Select Postgres Config in the SQL Services section of WHM.
7. Type a new PostgreSQL password in the text box and click Change Password.
   • Warning: Do not use non-alpha numeric characters, as these cause problems.
8. 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 ( pg_hba.conf).
9. 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.
10. PostgreSQL is now accessible from your cPanel interface.