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@prajnait.com> wrote in message
news:aiKdncTpIY1OHWiiXTWc-g@speakeasy.net...
> 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
>
>