Adventures in #pgsql, episode 1: Installed using aptitude. Went through create-new user dance. Figured out the template db is set to a useless encoding. Learnt how to regenerate the cluster using UTF-8.