On April 7, 2011, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> On Thu, 7 Apr 2011, Alan Hodgson wrote:
> > What does your pg_hba.conf file contain?
>
> Unmodified from the sample:
>
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
>
> @remove-line-for-nolocal@# "local" is for Unix domain socket connections
> only
> @remove-line-for-nolocal@local all all
> # IPv4 local connections:
> host all all 127.0.0.1/32
> @authmethod@ # IPv6 local connections:
> host all all ::1/128
> @authmethod@
>
> Rich
What is @authmethod@? That looks like a substitution parameter from something?
The default that should be in there is I think ident, which probably allows you to access it as rshepard but not the web server to do so, which is running under a different user.
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.
--
The era of procrastination, of half-measures, of soothing and baffling expedients, of delays, is coming to a close. In its place we are entering a period of consequences…