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
>
