Re: BUG #15911: Why no Bcrypt in pg_hba.conf? - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #15911: Why no Bcrypt in pg_hba.conf?
Date
Msg-id 20190717032612.GF2130@paquier.xyz
Whole thread Raw
In response to Re: BUG #15911: Why no Bcrypt in pg_hba.conf?  (raf <raf@raf.org>)
List pgsql-bugs
On Wed, Jul 17, 2019 at 09:22:42AM +1000, raf wrote:
> Tom Lane wrote:
>> Thus, we aren't going to add stuff on a whim, and when we do add some
>> new mechanism, there has to be a really solid argument that it's a
>> *significant* advance over what we have.

Agreed.  Adding a new authentication method is a lot of work as this
extends the protocol, and still with SCRAM we are not done yet with
drivers not linked directly with libpq, and I have some experience in
the area.

> bcrypt is better than pbkdf2 but pbkdf2 is still good
> for the same reasons that bcrypt is good (brute force
> resistance). if you want bcrypt/scrypt/argon2, pbkdf2
> will probably be good enough. and some organisations
> may require pbkdf2 because it is NIST-approved while
> the others aren't.

Good, we use PBKDF2 for the password salting.  If it is possible to
justify that this has much more benefits in the current practices, and
that we are still able to stick with the latest RFC specifications,
there may be an argument to get something done and improved, but I
don't quite see what that would be and more importantly if we actually
need to do so.
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: BUG #15911: Why no Bcrypt in pg_hba.conf?
Next
From: Michael Paquier
Date:
Subject: Re: BUG #15909: Doc for `initdb` on `--data-checksums` says "cannotbe changed later", but *can* be in Pg 12.