Installing PostgreSQL on Your cPanel/WHM Server

cPanel requires PostgreSQL 7.3.x or later.

First step is to update cpanel using /scripts/upcp from command line while logged in as root. If you have PostgreSQL 7.2.x installed, back up your databases using pg_dumpall.

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:

/scripts/installpostgres

From WHM now select Postgres Config in the SQL Services section of WHM. Type a new PostgreSQL password in the text box and click Change Password.

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.