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

(untested from here down)

mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/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 

- continue verifying install instructions