Very useful how-to for a newbie or someone from a mysql background
postgresql
http://hocuspok.us/journal/postgresql-on-ubuntu-linux-how-to-updated
phppgadmin
http://hocuspok.us/journal/installing-phppgadmin-on-ubuntu-linux
I write <code/> and occasionally prose