Re: PAM auth?

"Michael W. Lucas" <mwlucas@blackhelicopters.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