Re: BUG #16486: Prompted password is ignored when password specified in connection string - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16486: Prompted password is ignored when password specified in connection string
Date
Msg-id 2090524.1591652199@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16486: Prompted password is ignored when password specified in connection string  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16486: Prompted password is ignored when password specifiedin connection string  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
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.

            regards, tom lane



pgsql-bugs by date:

Previous
From: legrand legrand
Date:
Subject: pg_stat_statements: duplicated external query texts with MSY2
Next
From: Tom Lane
Date:
Subject: Re: BUG #16487: EXPLAIN produces JSON with duplicate "Workers" arrays