Re: Password Encryption and Connection Issues

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Password Encryption and Connection Issues
Date: 2025-07-09 15:28:41
Message-ID: 5535692f0b3095f591e76d3d51e1a76d87ffe85c.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2025-07-09 at 11:09 -0400, Ron Johnson wrote:
> > Best solution: Upgrade everyone to scram, then change md5 to scram
> > in pg_hba.conf and never look back.
>
> That requires setting the password to null and then recreating the
> password, no?  Otherwise IIRC, changing an md5 password leaves the
> new password also in md5 format.

No. The hashing algorithm chosen depends only on the current
setting of "password_encryption", not on the hashing algorithm
chosen for the previous password.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2025-07-09 15:50:49 Re: Password Encryption and Connection Issues
Previous Message Laurenz Albe 2025-07-09 15:26:02 Re: analyze-in-stages post upgrade questions