Installing postgres

From GridInfo

Installing postgresql

How to install postgresql from source on Mac OS X and Linux which is a prerequisite to both the Globus toolkit and the eMineral's project my_condor_submit submission tool.

Prerequisites

Postgres needs to run as its own user, so first add this user using either useradd under linux or the system preferences under OS X.

Building postgres

As root:

Download and decompress postgres somewhere

cd to the installation directory
./configure
make
make install
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test