PostgreSQL 8.1.3descriptionhttp://www.postgresql.org/PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
downloadclient, this package provides the psql command line client. If you wish to use SSL connections you will need to install openssl.
tools, this package provides tools for commonly performed tasks. These are clusterdb, createdb, createlang, createuser, dropdb, droplang, dropuser, pg_dump, pg_dumpall, pg_restore, reindexdb, vacuumdb. If you wish to use SSL connections you will need to install openssl.
server, this package contains the server. See notes below for quick start instructions. If you wish to use SSL connections you will need to install openssl.
devel, this contains the header and static library files.
notesAll 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 instructions1) 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.
CODE
adduser -D -h /mnt/hd/store/postgres postgres
2) login as the newly created user
CODE
su - postgres
3) create a directory for your database
CODE
mkdir data
4) tell postgresql to create your database cluster
CODE
initdb -D ~/data/
5) to start postgresql server
CODE
pg_ctl -D /mnt/hd/store/postgres/data -l /dev/null start
6) to stop postgresql server
CODE
pg_ctl -D /mnt/hd/store/postgres/data stop
7) read manual for full details
http://www.postgresql.org/docs/8.1/static/index.html8) For extra convenience you may want to create these aliases for starting/stopping the postgresql server:
CODE
alias pgstart='su - postgres -c '\''pg_ctl -D /mnt/hd/store/postgres/data -l /dev/null start'\'''
alias pgstop='su - postgres -c '\''pg_ctl -D /mnt/hd/store/postgres/data stop'\'''
I would like to add a learning mode for vocabulary training 
