On Thu, 7 Apr 2011, Alan Hodgson wrote:
What is @authmethod@? That looks like a substitution parameter from something?
Alan, Oops! Copied tail of wrong file. It's not at the end of /usr/local/pgsql/data/pg_hba.conf. That has: # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust
Try changing the auth method on 127.0.0.1/32 to trust (just for testing), and then if that works set it to md5 and assign a password.
That's what it is: trust. Rich