Installing Postgresql on Linux server
Installing Postgresql on Linux serverRequirements :
cPanel requires Postgresql 7.3.x or later. As the 7.2.x will not work.
Installation:
Step 1: Upgrade to cPanel 7.4.0 build 45 or later
Step 1:a (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 2:a (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!
posted by The Great Anil @ 11:58 PM
Comments: 0
