From: Mark Steben <msteben@autorevenue.com>
To: pgsql-admin@postgresql.org
Subject: password administration
Date: Thu, 5 Aug 2010 15:58:06 -0400
Message-ID: <20100805200454.17A64632749@mail.postgresql.org> (raw)
Hi postgres gurus:
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. Preferably, I'd like to use
The 'rolvaliduntil' column in pg_roles.
I'm wondering if there is an app inside or outside of postgres
that I can use or do I have to design from scratch.
Thanks for your time,
Mark Steben | Database Administrator
@utoRevenue® - "Keeping Customers Close"
95D Ashley Ave, West Springfield, MA 01089
413.243.4800 x1512 (Phone) |413.732-1824 (Fax)
@utoRevenue is a registered trademark and a division of Dominion
Enterprises
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: msteben@autorevenue.com
Subject: Re: password administration
In-Reply-To: <20100805200454.17A64632749@mail.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox