From: Bob Lunney <bob_lunney@yahoo.com>
To: pgsql-admin@postgresql.org, Mark Steben <msteben@autorevenue.com>
Subject: Re: password administration
Date: Thu, 5 Aug 2010 18:32:54 -0700 (PDT)
Message-ID: <133373.78610.qm@web39701.mail.mud.yahoo.com> (raw)
In-Reply-To: <20100805200454.17A64632749@mail.postgresql.org>
Mark,
Look into kerberos. You will have to recompile your server to use it.
Bob Lunney
--- On Thu, 8/5/10, Mark Steben <msteben@autorevenue.com> wrote:
> From: Mark Steben <msteben@autorevenue.com>
> Subject: [ADMIN] password administration
> To: pgsql-admin@postgresql.org
> Date: Thursday, August 5, 2010, 3:58 PM
>
>
> 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
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
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: bob_lunney@yahoo.com, msteben@autorevenue.com
Subject: Re: password administration
In-Reply-To: <133373.78610.qm@web39701.mail.mud.yahoo.com>
* 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