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.
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 For extra convenience you may want to create these aliases for starting/stopping the postgresql server:
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'\'''