Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 9954F632AA4 for ; Thu, 5 Aug 2010 17:05:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 74156-02 for ; Thu, 5 Aug 2010 20:04:53 +0000 (UTC) X-Greylist: delayed 00:06:40.315287 by SQLgrey-1.7.6 Received: from mail.autorevenue.com (mail.autorevenue.com [208.178.167.106]) by mail.postgresql.org (Postfix) with ESMTP id 17A64632749 for ; Thu, 5 Aug 2010 17:04:53 -0300 (ADT) Received: (qmail 7240 invoked from network); 5 Aug 2010 15:59:05 -0400 Received: from unknown (HELO dei26g028534) (msteben@10.10.6.101) by mail.autorevenue.com with SMTP; 5 Aug 2010 15:59:05 -0400 From: "Mark Steben" To: Subject: password administration Date: Thu, 5 Aug 2010 15:58:06 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: Acs02IVb4xeDsW/iSMyER6lgL0zPgw== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931 Message-Id: <20100805200454.17A64632749@mail.postgresql.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/28 X-Sequence-Number: 35277 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=20 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=A0|=A0Database Administrator=A0 @utoRevenue=AE - "Keeping Customers Close"=A0 95D Ashley Ave, West Springfield, MA 01089=20 413.243.4800 x1512 (Phone) |413.732-1824 (Fax)=20 @utoRevenue is a registered trademark and a division of Dominion Enterprises=A0 =A0