Re: encrypted passwords

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: encrypted passwords
Дата
Msg-id 17229.1029366074@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: encrypted passwords  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> It also allowed auto-migration to encrypted passwords from an old dump
> file.

Ah, right, that was it: we wanted to be able to have a pg_dumpall script
containing a mix of crypted and noncrypted passwords in CREATE USER
commands be loaded either as-is, or have all the passwords forced to
crypted form, depending on the setting of password_encryption.  So we
didn't really want the CREATE USER commands in the script to say exactly
what to do.  Therefore, in the design as released the CREATE USER
commands emitted by pg_dumpall don't actually say either ENCRYPTED or
UNENCRYPTED.  We didn't see a need for ALREADY_CRYPTED either,
figuring that it would actually be more reliable to deduce that by
looking at the data than by having a separate flag for it.
        regards, tom lane


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

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: journaling in contrib ...
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: anoncvs - here we go again!