PostgreSQL can not run in ROOT user.

Command line:

#useradd postgre

#tar xvfz postgresql_7.1.3.tar.gz

#cd postgresql_7.1.3

#./configure –prefix=/usr/local/pgsql

#make

#make install

#chown –R postgre.postgre /usr/local/psql

#emacs ~postgre/.bash_profile

add:

PGLIB=/usr/local/pgsql/lib

PGDATA=$HOME/data

PATH=$PATH:/usr/local/pgsql/bin

MANPATH=$MANPATH:/usr/local/pgsql/man

export PGLIB PGDATA PATH MANPATH

Then use postgres user login

#su – postgre

create database direct

#mkdir data

start database

#initdb

$postmaster –i –D ~/data &

psql –h pgdbs.inf.brad.ac.uk