PostgerSQL Installation

Purpose:
This is a installation document how to installation the postgreSQL on linux server.
Procedure:
1. Save the installation file under /usr/local/src
2. unzip the installation file
#tar zxpvf postgresql-8.1.3.tar.gz
3. # cd postgresql-8.1.3
./configure
gmake
su
gmake install
adduser postgres
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
需要修改postgresql.conf和pg_hba.conf文件.

参见postgresql8.1 版本中文手册 http://www.pgsqldb.org/pgsqldoc-8.1c/index.html