Re: Postgres and PAM config issues - Mailing list pgsql-admin

From Tomasz Myrta
Subject Re: Postgres and PAM config issues
Date
Msg-id 46BC79ED.3030404@klaster.net
Whole thread Raw
In response to Postgres and PAM config issues  ("Marcin Porwit" <mporwit@yahoo-inc.com>)
List pgsql-admin
Marcin Porwit napisal 2007-08-10 03:26:
>        positionwhile[pg]% more /etc/pam.d/postgresql
>        #%PAM-1.0
>        auth       required     pam_stack.so service=system-auth
>
> The system is a CentOS 4.4 box, and I'm running PostgreSQL 8.0.6.
>
> However, when I try to get psql to do password authentication, I get the
> following:
>     positionwhile[postgresql-8.0.13]% psql authtest
>     Password:
>     psql: FATAL:  PAM authentication failed for user "mporwit"

Probably you are missing "account" section in your pam configuration.

Regards,
Tomasz Myrta

pgsql-admin by date:

Previous
From: Witold Gołąb
Date:
Subject: exclude logs of one database from log
Next
From: "Chris Hoover"
Date:
Subject: Easy way to change table schema?