How to install postgresql

Steps given below :-

*Not:- C-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 & 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!

 

 

******************************************--------------------------****************************************