PostgreSQL (install and run)

Run and test passed on Redhat 9.0

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