Hi Team,
Just a quick check
As per documentation, for upgrading password encryption from md5 to scram-sha-256, we have to set password_encryption to scram-sha-256, reset the user password and then change in pg_hba.conf.
Is there any other way to do this without changing the password? if there are a lot of login users in the database it becomes difficult and it may incur downtime as well.
I see there is a way the users can do it by themselves but still will incur some downtime.
Thanks and Regards,
Nikhil
