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