New Packages Announcement, *PACKAGE ANNOUNCEMENTS ONLY* Options

[desertrat]

This thread is reserved solely for announcements of newly available or updated contributed packages[*] so that people can just check one thread to see what goodies are available.

One package (or set of closely related packages) per post.

If you want to discuss/report bugs etc on the packages then start a new thread.

The current list of contributed packages is here:
http://mail.pdaxrom.org/contrib/list.txt

For a vaguely categorised list go here:
http://mail.pdaxrom.org/contrib/

If you would like to contribute a package (or documentation) but don't have (or don't want to use) your own webspace then see this post:
http://www.oesf.org/forums/index.php?showtopic=18285

[*] contributed packages are those that have been made by regular pdaXrom users and are not yet in the official feed


ps: Laze, could you please pin this thread

[desertrat]

PostgreSQL 8.1.3

description
http://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.

download
client, 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.

notes
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.

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.html

8) 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'\'''