PostgreSQL

• download source from http://www.postgresql.org
• create a 'postgres' user account

./configure --prefix=/usr/local/pgsql --mandir=/usr/local/man --infodir=/usr/local/info

make

sudo make install

sudo mkdir /usr/local/pgsql/data
sudo chown postgres:postgres /usr/local/pgsql/data
sudo su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
(cd to or replace logfile with your desired logfile name)
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test 
/usr/local/pgsql/bin/psql test 

• psql (command line, included with PostgreSQL)
• pgAdmin (GUI)

• creating_startup_items

• http://www.postgresql.org/docs/8.3/interactive/postgres-user.html