On Tue, Mar 14, 2017 at 11:47 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> I'm not talking about changing the default, just having it be possible
>> to use \password with the new system as it was with the old, whatever
>> exactly we think that means.
I think that this means looking at password_encryption within
PQencryptPassword(), something that could silently break some
applications. That's why with Joe we are mentioning upthread to extend
PQencryptPassword() with a hashing method, and have a function to
allow retrieval of the password type for a given user.
> Seems to me the intended behavior of \password is to use the best
> available practice. So my guess is that it ought to use SCRAM when
> talking to a >= 10.0 server. What the previous password was ought
> to be irrelevant, even if it could find that out which it shouldn't
> be able to IMO.
And in a release or two? SCRAM being a fresh feature, switching the
hashing now is not much a conservative approach.
--
Michael