"Mark Steben" <msteben(at)autorevenue(dot)com> writes:
> I would like to set up a facility that enforces password changes for roles
> After a predefined period (30 days for instance) when logging into psql
> Or, at the very least, send an email out to notify that your current
> Password period is about to expire.
Usually we suggest using PAM when you want to do this, as there's all
sorts of spare parts out there already for PAM-managed passwords.
(I concur with the response questioning whether forced password changes
are good policy, especially with an interval as short as that. But if
you've got bullheaded management to deal with, PAM is the place to
look.)
regards, tom lane