POSTGRES

1. Postgres Installation on Centos 6.3

./configure --prefix=/usr/local/postgresql-9.2.2 --with-ldap --with-pam
gmake
su
gmake install
adduser postgres
mkdir /usr/local/postgresql-9.2.2/data
chown postgres /usr/local/postgresql-9.2.2/data
su - postgres
/usr/local/postgresql-9.2.2/bin/initdb -D /usr/local/postgresql-9.2.2/data
/usr/local/postgresql-9.2.2/bin/postgres -D /usr/local/postgresql-9.2.2/data >logfile 2>&1 &
/usr/local/postgresql-9.2.2/bin/createdb test
/usr/local/postgresql-9.2.2/bin/psql test
/usr/local/postgresql-9.2.2/bin/dropdb test