BUG #1763: PAM Authentication not working...

The following bug has been logged online:

Bug reference:      1763
Logged by:          Sham Rao
Email address:      sham@styk.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"