How to Install postgresql on cPanel server

Panel requires Postgresql 7.3.x or later. 7.2.x will not work.Step 1

Upgrade to cPanel 7.4.0 build 45 or later

Step 1a (If you do not have 7.2.x or earlier installed skip this step)

Login to a root shell via ssh or the console.

If you have Postgres 7.2.x installed, backup your databases using pg_dumpall or some other method.

Move the postgres data directory somewhere else. ie

mv /var/lib/pgsql /var/lib/pgsql.old

Step 2

Login to a root shell via ssh or the console and run

/scripts/installpostgres

>Step 2a (skip this step if you are not upgrading from postgres 7.2 or earlier

>Restore your sql dump created with pg_dumpall or by some other method using psql or some other method

Step 3

Login to Web Host Manager and choose “Postgres Config” under Server Setup.

Set a postgres password to anything of your choosing. You should avoid using any non-alpha numeric charaters as these cause problems.



Step 4

>Use the “Postgres Config” option in WHM to install a postgres pg_hba.conf file. You can skip this step if you would like to setup your pg_hba.conf file manually. cPanel should work fine with md5 passwords or plaintext passwords

Step 5

Login to cPanel and click on Postgres .. Enjoy!