Installing PostgreSQL on Your cPanel & WHM Server
For cPanel & WHM versions 11.25/26
Installing PostgreSQL is not a difficult process, but you should follow the steps below in order to ensure that everything is properly configured.
cPanel requires PostgreSQL 7.3.x or later. Earlier versions will not work.
- If necessary, update to cPanel 7.4.0 build 45 (or later).
- You can update cPanel by typing
/scripts/upcp from the command line while logged in as root.
- 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 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
- Type the following command:
- From your web browser, log into WebHost Manager.
- Select Postgres Config in the SQL Services section of WHM.
- 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.
- 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
Topic revision: r6 - 02 Dec 2010 - 15:24:44 - MelanieSeibert