Wednesday, March 11, 2009

Installing PostgreSQL On Cpanel

Installing PostgreSQL


Install PostgreSQL using cPanel


To install PostgreSQL on the server that is running a cPanel server, complete the following:

1. Login as root
2. Type:

cd /scripts/
./installpostgres


3. cPanel will automatically install PostgreSQL using yum and initialize the database for you.

Install PostgreSQL using yum

Yum can be used to install PostgreSQL on a RedHat or CentOS platform. Run the following commands to get PostgreSQL installed with yum.

yum install postgresql postgresql-server postgresql-libs postgresql-devel
/etc/rc.d/init.d/postgresql start


-OR-

yum install postgresql postgresql-server postgresql-libs postgresql-devel
/etc/rc.d/init.d/postgresql initdb
/etc/rc.d/init.d/postgresql start

++++++++++++++++++++++++++++++++++++++