On Thu, Mar 16, 2017 at 11:38 PM, Michael Paquier <michael.paqu...@gmail.com> wrote: > On Thu, Mar 16, 2017 at 10:52 PM, Heikki Linnakangas <hlinn...@iki.fi> wrote: >> On 03/14/2017 11:14 PM, Tom Lane wrote: >>> >>> In short, I don't think that argument refutes my position that "md5" >>> in pg_hba.conf should be understood as allowing SCRAM passwords too. >> >> >> Yeah, let's do that. Here's a patch. > > At least this has the merit of making \password simpler from psql > without a kind of --method option: if the backend is 9.6 or older, > just generate a MD5-hash, and SCRAM-hash for newer versions. > PQencryptPassword still needs to be extended so as it accepts a hash > method though.
What if the user doesn't want to switch to SCRAM because they also use some connector that hasn't been updated to support it? I bet there will be a lot of people in that situation. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers