From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Michael W(dot) Lucas" <mwlucas(at)blackhelicopters(dot)org> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: PAM auth? |
Date: | 2012-06-07 19:17:19 |
Message-ID: | 11653.1339096639@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
"Michael W. Lucas" <mwlucas(at)blackhelicopters(dot)org> writes:
> I'm running 9.1.2 on FreeBSD 9, installed via OS vendor package, and
> trying to get PAM auth to work.
> From what I've read, this should be as simple as the following
> /usr/local/share/postgres/pg_hba.conf:
Um ... that is not where the pg_hba.conf file should go, in any standard
configuration. Try putting it in your $PGDATA directory. (Actually I
think "show hba_file;" should tell you where the database thinks it
should be.)
> host all all 0.0.0.0/0 pam postgresql
> local all all 0.0.0.0/0 pam postgresql
I think the last field needs to read "pamservice=postgresql".
I'm not qualified to debug your pam configuration file, but from the
symptoms it sounds like the database isn't looking at it yet.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Seaman | 2012-06-07 19:58:21 | Re: PAM auth? |
Previous Message | Michael W. Lucas | 2012-06-07 19:03:17 | PAM auth? |