BUG #1763: PAM Authentication not working...

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"