Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> writes: > I just tried this from the command line and it let me right in: > psql template1 -U postgres > Didn't ask for a password or anything, and the localhost entry in > pg_hba.conf is also set for md5. You sure you restarted the postmaster (or did pg_ctl reload) after changing the pg_hba.conf file? Is it possible there's another postmaster on the machine that's the one you're actually connecting to? Also, since you evidently did not show us all of pg_hba.conf the first time, let's see it all. regards, tom lane