/etc/postgresql/8.3/main/pg_hba.conf

local   all         all                               md5
host    all         all         127.0.0.1/32          md5

http://www.postgresql.org/