Re: Connecting PHP-based Application to Postgres-9.0.3

On April 7, 2011, Rich Shepard <[email protected]> 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…