Installing Postgresql – HOWTO
cPanel 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
===========================================
29110310
===========================================
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
===========================================