"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