postgresql on debian

I've installed this on storm already but I'm here on rod and it needs doing so I'm blogging it

# apt-get install postgresql-8.1
# apt-get install postgresql-contrib-8.1
# su -l postgres
; psql template1 < /usr/share/postgresql/8.1/contrib/tsearch2.sql
; echo 'create language plpgsql' | psql template1
; createuser webmaster
; createuser www
; echo 'alter user www password ''[the password]''; alter user webmaster password ''[the password]'';' | psql

# ed /etc/postgresql/8.1/main/pg_hba.conf
/all *ident
s/ident/md5/
wq
# /etc/init.d/postgresql-8.1 restart
# su -l maht
; cat << EOF > .pgpass
cat
*:*:*:www:[the password]
*:*:*:webmaster:[the password]
EOF

add this to the appropriate entry in lighttpd.conf
setenv.add-environment = (
"DB" => "host=localhost dbname=bang user=www password=[the password]",
"STORY_TREE" => "/var/www/bang/story_tree",
)

k here's how to create bang database
; createdb -O webmaster bang
; sed 's/_postgresql/postgres/g' pg_bang-live.sql | psql bang

then I had to make sure $_SERVER variables were referenced in upper case
uri bits needs sorting out a la storm, I cba doing that now, Bang's index page is running that'll do me