Upgrading password encryption from md5 to scram-sh-256

Поиск
Список
Период
Сортировка
От Nikhil Shetty
Тема Upgrading password encryption from md5 to scram-sh-256
Дата
Msg-id CAFpL5VytCu6h4n1hnaRS1BYTNW8uv5jx_FDERwssL_vCNYAfzw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Upgrading password encryption from md5 to scram-sh-256  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Upgrading password encryption from md5 to scram-sh-256  (Holger Jakobs <holger@jakobs.com>)
Re: Upgrading password encryption from md5 to scram-sh-256  (Jonathan Katz <jonathan.katz@excoventures.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Holger Jakobs
Дата:
Сообщение: Re: now() and statement_timestamp()
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Upgrading password encryption from md5 to scram-sh-256