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 428207.1599076060@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #16486: Prompted password is ignored when password specified in connection string  (Bruce Momjian <bruce@momjian.us>)
Responses Re: BUG #16486: Prompted password is ignored when password specified in connection string  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
Bruce Momjian <bruce@momjian.us> writes:
> I used a later version of Tom's patch to add documentation of how
> connection strings can override command-line options, plus it has the
> password description improvements.

>          <option>--all</option>) is not used, the database name is read
>          from the environment variable <envar>PGDATABASE</envar>.  If
>          that is not set, the user name specified for the connection is
> -        used.
> +        used.  <link linkend="libpq-connstring">Connction strings</link>
> +        can also be used for connection specifications, and these can
> +        override other command-line options.
>         </para>
>        </listitem>
>       </varlistentry>

* Spellcheck (not "Connction" please)

* I do not like the wording "can override", because that's just impossibly
vague.  It leaves the reader wondering whether there are cases where that
doesn't happen.

I'd suggest wording more like

    The <replaceable>dbname</replaceable> can be a
    <link ...>connection string</link>.  If so, connection parameters
    found in the connection string will override any conflicting command
    line options, such as <option>--username</option>.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [BUG v13] Crash with event trigger in extension
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: BUG #16605: PostgreSQL recovery startup process waiting and blocking to application queries