Re: Connecting PHP-based Application to Postgres-9.0.3

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