Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 7F627632A27 for ; Thu, 5 Aug 2010 22:33:09 -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 37401-02 for ; Fri, 6 Aug 2010 01:32:55 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web39701.mail.mud.yahoo.com (web39701.mail.mud.yahoo.com [209.191.106.47]) by mail.postgresql.org (Postfix) with SMTP id 37E6C6324CA for ; Thu, 5 Aug 2010 22:32:57 -0300 (ADT) Received: (qmail 79084 invoked by uid 60001); 6 Aug 2010 01:32:54 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1281058374; bh=q0MEWOG6HUOvv9NEqWXGRbIeWZBECnX+mn/9HkvoV0w=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=uU6arhBjTPnYi5dH+W5I9osAThF3UC0qQNkout2RwylNQZifAKOw16gqYEVXktBgzUtv13b+amjdtZIofQxswU34quReQRZSbvb+RuZ5XkF/OE1WdU3Ggr1Xo56TPwU3tEbw/EwhFni9MDnHmJMDaHpBN0EyV/N1vh9f37OCWCg= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=yjzdTXuW4uzpeMQtbRry71AD1QEWKousPc3vsp8xNitozGMxa6ylF8m3zdgHYREJeCUimeSBE9ylDoq5S2ldCCiF2NmwNNjfbjkU9hjWF8OS37M09+bHmeSWcB/A1tP3f9LOj283TMMZ5MLBBQhOjjDv6VtSap+kLTeGgNNc+Rg=; Message-ID: <133373.78610.qm@web39701.mail.mud.yahoo.com> X-YMail-OSG: UTgjDTcVM1lVlf2G_mj2LrfirKCSFPVJB4D4IqJT1yFc8.H _VUmjFNm8fjfQnanYiYI2vsoOHg55mHTXEQuret4fdv3BlBic2uhVCe_1Hf9 z9.h0TUdoN0fL5DKDojM.BWrKuCuyNpF6Ji9OCpqPk_6FR244fqkAbjdXh8N mSOx.I41NMcvOkqliUBTX7EPAZO1hOIqszSR.Li51P27Nv.HeDtkEqqy7LQG odXaJZlQ_rL5q9akvwBt7k3MoBgHJg2nW.o2J8KPPoAausKC.5g6i3r8IY8. HKlB0oOnnt..gheHtuQNmHEocb6o5VfC67YwAfauckkNfO5lolZVIfhDDR8b CoYFol3DLodptFNLUHs6sDg-- Received: from [64.126.29.122] by web39701.mail.mud.yahoo.com via HTTP; Thu, 05 Aug 2010 18:32:54 PDT X-Mailer: YahooMailClassic/11.3.2 YahooMailWebService/0.8.105.279950 Date: Thu, 5 Aug 2010 18:32:54 -0700 (PDT) From: Bob Lunney Subject: Re: password administration To: pgsql-admin@postgresql.org, Mark Steben In-Reply-To: <20100805200454.17A64632749@mail.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/39 X-Sequence-Number: 35288 Mark,=0A=0ALook into kerberos. You will have to recompile your server to u= se it.=0A=0ABob Lunney=0A=0A--- On Thu, 8/5/10, Mark Steben wrote:=0A=0A> From: Mark Steben =0A> Su= bject: [ADMIN] password administration=0A> To: pgsql-admin@postgresql.org= =0A> Date: Thursday, August 5, 2010, 3:58 PM=0A> =0A> =0A> Hi postgres guru= s:=0A> =0A> I would like to set up a facility that enforces password=0A> ch= anges for roles=0A> After a predefined period (30 days for instance) when= =0A> logging into psql=0A> Or, at the very least, send an email out to noti= fy that=0A> your current =0A> Password period is about to expire.=A0 Prefer= ably, I'd=0A> like to use=0A> The 'rolvaliduntil' column in pg_roles.=0A> = =0A> I'm wondering if there is an app inside or outside of=0A> postgres=0A>= that I can use or do I have to design from scratch.=0A> =0A> Thanks for yo= ur time,=0A> =0A> =0A> Mark Steben=A0|=A0Database Administrator=A0=0A> @uto= Revenue=AE - "Keeping Customers Close"=A0=0A> 95D Ashley Ave, West Springfi= eld, MA 01089 =0A> 413.243.4800 x1512 (Phone) |413.732-1824 (Fax) =0A> @uto= Revenue is a registered trademark and a division of=0A> Dominion=0A> Enterp= rises=A0=0A> =A0=0A> =0A> =0A> =0A> =0A> -- =0A> Sent via pgsql-admin maili= ng list (pgsql-admin@postgresql.org)=0A> To make changes to your subscripti= on:=0A> http://www.postgresql.org/mailpref/pgsql-admin=0A> =0A=0A=0A