Re: 7.4 Alter User xxx VALID UNTIL '2000-01-01' does not work

NEVER MIND. I found this post:

http://archives.postgresql.org/pgsql-hackers/2003-03/msg00671.php

Actually I'd found it before but the site was down for a few minutes and so
I couldn't read that page. The gist is:
1. expirations apply to passwords not accounts
2. and, of course, passwords aren't check when using non-pw based
connection schemes (e.g., Ident).

== Ezra E.

"ezra epstein" <ee_newsgroup_post(at)prajnait(dot)com> wrote in message
news:aiKdncTpIY1OHWiiXTWc-g(at)speakeasy(dot)net(dot)(dot)(dot)
> I'm trying to keep a user around but make it invalid. E.g., by setting
the
> valid until to be a time in the past. I've tried this:
>
> alter user pw_config valid until 'Jan 31 2001';
>
> and this:
>
> alter user pw_config valid until '2000-01-01';
>
> and even this:
>
> alter user pw_config valid until '-infinity'; -- for good measure
>
> and none of them seems to have an affect. The field is changed (pg_admin
> says so) but psql still lets the user connect and execute statements.
>
> Help!
>
> == Ezra Epstein
>
>