To install postgresql
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

/scripts/installpostgres


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.

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.

Login to cPanel and click on Postgres .. Enjoy

1. phpPgAdmin shows ALL the databases to user by default even if he's not the owner. It can be fixed by editing conf-file.
2. By default pgsql does not allow network connections, but phpPgAdmin uses network connection to pgsql instead of unix domain socket.
3. User is able to see all the databases in the system with psql AND ABLE TO CREATE TABLES IN DATABASES OF OTHER PERSONS (!!!!!!!!!)
4. Unable to delete database through Cpanel (even if it's been created with Cpanel).