Re: [HACKERS] password_encryption, default and 'plain' support

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: [HACKERS] password_encryption, default and 'plain' support
Дата
Msg-id 5ffa6845-7026-e376-2877-0b2afb0f908a@iki.fi
обсуждение исходный текст
Ответ на Re: [HACKERS] password_encryption, default and 'plain' support  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] password_encryption, default and 'plain' support  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
On 05/03/2017 08:40 PM, Tom Lane wrote:
> The other question I can think to ask is what will happen during
> pg_upgrade, given an existing installation with one or more passwords
> stored plain.  If the answer is "silently convert to MD5", I'd be
> good with that.

Yes, it will silently convert to MD5. That happened even on earlier 
versions, if you had password_encryption=on in the new cluster (which 
was the default).

I'm planning to go ahead with the attached patch for this (removing 
password_encryption='plain' support, but keeping the default as 'md5').

- Heikki


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: [HACKERS] statement_timeout is not working as expected with postgres_fdw
Следующее
От: Rahila Syed
Дата:
Сообщение: Re: [HACKERS] Adding support for Default partition in partitioning