Is it just the password that expires or the account? The comment for valid until says the password is valid until that time. However, one of the examples says the account is valid until that time.
In response to
Re: ALTER USER at 2003-03-16 18:05:43 from Alvaro Herrera