Postgres Pro
Downloads
Home   >   mailing lists

Upgrading password encryption from md5 to scram-sh-256 - Mailing list pgsql-admin

From Nikhil Shetty
Subject Upgrading password encryption from md5 to scram-sh-256
Date
Msg-id CAFpL5VytCu6h4n1hnaRS1BYTNW8uv5jx_FDERwssL_vCNYAfzw@mail.gmail.com
Whole thread Raw
Responses Re: Upgrading password encryption from md5 to scram-sh-256
Re: Upgrading password encryption from md5 to scram-sh-256
Re: Upgrading password encryption from md5 to scram-sh-256
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: now() and statement_timestamp()
Next
From: Laurenz Albe
Date:
Subject: Re: Upgrading password encryption from md5 to scram-sh-256