Skip site navigation (1) Skip section navigation (2)

Re: fallback authentication

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Ron Peterson <rpeterso(at)mtholyoke(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: fallback authentication
Date: 2004-12-12 05:43:08
Message-ID: 20041212054308.GA28684@wolff.to (view raw or flat)
Thread:
Lists: pgsql-admin
On Sat, Dec 11, 2004 at 22:55:55 -0500,
  Ron Peterson <rpeterso(at)mtholyoke(dot)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.)

In response to

Responses

pgsql-admin by date

Next:From: Paulo JobimDate: 2004-12-12 16:39:58
Subject: HELP database files are incompatible with server
Previous:From: Philip Michael D VargasDate: 2004-12-12 05:33:28
Subject: i need help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group