Re: password administration

Mark,

Look into kerberos. You will have to recompile your server to use it.

Bob Lunney

--- On Thu, 8/5/10, Mark Steben <msteben(at)autorevenue(dot)com> wrote:

> From: Mark Steben <msteben(at)autorevenue(dot)com>
> Subject: [ADMIN] password administration
> To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>