Re: Serious problem within authentication subsystem in 7.0

Tom Lane writes:

> Peter Eisentraut <peter_e@gmx.net> writes:
> > But if you have different passwords between databases then you are still
> > having the same problem, only at a different scale.
> 
> ... which we do not have, at the moment; there's one password per user
> per installation,

No, pg_hba.conf allows per database passwords.

> In any case, isn't psql's logic such that it will prompt again if the
> previous password doesn't work?

No, it will only prompt you for a password if it notices one is required.
If that's wrong the connection attempt fails and you can try again (to
connect). That's reasonable enough I think.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden