The following bug has been logged online:

Bug reference: 1763
Logged by: Sham Rao
Email address: sham (AT) styk (DOT) net
PostgreSQL version: 8.0.3
Operating system: SuSe Linux 9.3
Description: PAM Authentication not working...
Details:

No matter what configuration I use I cannot get postgres to authenticate a
user with pam.

The following are the relevent lines of my configuration.

/etc/pam.d/postgresql
#%PAM-1.0
auth required pam_permit.so
auth required pam_warn.so

==> /var/log/messages <==
Jul 11 22:02:16 custodian PAM-warn[26850]: function=[pam_sm_authenticate]
service=[postgresql] terminal=[<unknown>] user=[sham] ruser=[<unknown>]
rhost=[<unknown>]
Jul 11 22:02:16 custodian PAM-warn[26850]: function=[pam_sm_acct_mgmt]
service=[postgresql] terminal=[<unknown>] user=[sham] ruser=[<unknown>]
rhost=[<unknown>]

==> /var/log/postgresql <==
LOG: pam_acct_mgmt failed: User account has expired
FATAL: PAM authentication failed for user "sham"

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

On Tue, Jul 12, 2005 at 05:59:36AM +0100, Sham Rao wrote:
Note that you need the user to be created in PostgreSQL as well as your
PAM system. However apparently your problem is something else:

Maybe you need to give the user a newer, non-expired password.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Nadie esta tan esclavizado como el que se cree libre no siendolo" (Goethe)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq