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