Re: fallback authentication - Mailing list pgsql-admin

On Sat, Dec 11, 2004 at 22:55:55 -0500,
  Ron Peterson <rpeterso@mtholyoke.edu> wrote:
>
> I have:
>
> host    all         all         127.0.0.1         255.255.255.255   md5
> host    all         all         127.0.0.1         255.255.255.255   pam postgresql
> host    all         all         0.0.0.0           0.0.0.0           reject
>
> I've also tried reversing the first two lines.  Either strategy
> individually works, but I'd like lookups which don't work locally to try
> pam (or vice-versa).  What am I missing?

You can't use 'all' for the username specification. You need to explicitly
list out the usernames in the first host line. (Which should be the md5
line.)