Mark, You could use LDAP to? that? I use LDAP + apache []´s Victor Hugo 2010/8/5 Tom Lane <tgl@xxxxxxxxxxxxx>: > "Mark Steben" <msteben@xxxxxxxxxxxxxxx> 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 > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- []´s Victor Hugo -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin