Re: BUG #16486: Prompted password is ignored when password specifiedin connection string

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #16486: Prompted password is ignored when password specifiedin connection string
Дата
Msg-id CAKFQuwbk=SDVVhe=P=eAsX4Zip_0tR+vZOOMM-VvHAH0=We=_g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #16486: Prompted password is ignored when password specified in connection string  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #16486: Prompted password is ignored when password specified in connection string  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
On Mon, Jun 8, 2020 at 2:36 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
PG Bug reporting form <noreply@postgresql.org> writes:
> Assuming that we have the user u1 with the password p1, the following
> command:
> psql -U u1 'dbname=postgres password=p1' -W
> prompts for a password but the input password is effectively ignored.

The entire point of the -W switch is that it prompts whether or not
the password is going to be used for anything.  If you don't like that,
don't use -W.

A more intuitive interpretation of -W is that it prompts for a password, regardless of valid values being provided by other configuration, and uses that password exclusively to attempt to connect to the server.

The documentation doesn't actually say which one of those two interpretations is correct.

And regardless of which interpretation is intended the OP seems to demonstrate that either interpretation is reality depending on which combination of configuration sources provide the non-prompted password.  That inconsistency seems undesirable.

David J.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16487: EXPLAIN produces JSON with duplicate "Workers" arrays
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16486: Prompted password is ignored when password specified in connection string