postgresql-server
=================

NB all the postgresql components are installed in
'/usr/local/postgresql'. For convenience you may want to
edit '/etc/profile' and add '/usr/local/postgresql/bin' to
the PATH.


Quick start instructions

1) create a new user to handle the database, in this example
the user will be 'postgres' and its home directory will be
'/mnt/hd/store/postgres'. Make sure there is enough free space in
that partition to store your data.

  adduser -D -h /mnt/hd/store/postgres postgres

2) login as the newly created user

  su - postgres

3) create a directory for your database

  mkdir data

4) tell postgresql to create your database cluster

  initdb -D ~/data/

5) to start postgresql server

  pg_ctl -D /mnt/hd/store/postgres/data -l /dev/null start

6) to stop postgresql server

  pg_ctl -D /mnt/hd/store/postgres/data stop

7) read manual for full details

  http://www.postgresql.org/docs/8.1/static/index.html