Re: \password in psql help
От
Alvaro Herrera
Тема
Re: \password in psql help
Дата
Msg-id
20080326134348.GC8100@alvh.no-ip.org
Ответ на
Re: \password in psql help (Heikki Linnakangas)
Список
Дерево обсуждения
\password in psql help Magnus Hagander <magnus@hagander.net>
Re: \password in psql help Tom Lane <tgl@sss.pgh.pa.us>
Re: \password in psql help Magnus Hagander <magnus@hagander.net>
Re: \password in psql help Tom Lane <tgl@sss.pgh.pa.us>
Re: \password in psql help Magnus Hagander <magnus@hagander.net>
Re: \password in psql help "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: \password in psql help Alvaro Herrera <alvherre@commandprompt.com>
Re: \password in psql help Magnus Hagander <magnus@hagander.net>
Heikki Linnakangas wrote:
> Magnus Hagander wrote:
>> + fprintf(output, _(" \\password [USERNAME]\n"
>> + " securely change the password for a user\n"));
>
> I would leave out the word "securely". Unless you want to provide
> another command for changing it insecurely ;-). What does it mean,
> anyway?
The point is that the password is encrypted on the client and
transmitted in md5 form. If you were to use ALTER USER to change the
password, it could end up unencrypted in the server log.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-patches по дате отправления
