On 2020-05-28 18:38, Christoph Berg wrote:
> Why do I have to decide*in pg_hba.conf* which hash algorithm is used?
> Why can't that just be "password"?
>
> The password_encryption GUC should be the only place concerned with
> that, and it should only be used for new passwords. Existing passwords
> should just continue to work.*That* would allow seamless upgrades.
You get that if you set the authentication method to "md5". (Clearly
not a very clear name, but it exists.)
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services