Re: BUG #16746: [PG12.5 psql] Password ignored by connect meta-command

Tom, will need your input here.

On Thu, Nov 26, 2020 at 4:09 AM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 16746
> Logged by: Krzysztof Gradek
> Email address: kgradekx(at)gmail(dot)com
> PostgreSQL version: 12.5
> Operating system: Centos
> Description:
>
> Hi
> I just migrated my app to PG 12.5 and jumped into an issue which didn't
> exist in PG12.3: the password provided in connection URI is ignored by
> connect meta-command.
> [...]
> $ psql
> psql (12.5)
> Type "help" for help.
>
> postgres=# \connect
> postgresql://ph_quartz_user:password(at)127(dot)0(dot)0(dot)1/ph_quartz
> Password for user ph_quartz_user:
>
> Same sequence using earlier version:
> $ /usr/pgsql-9.4/bin/psql
> psql (9.4.4, server 12.5)
> WARNING: psql major version 9.4, server major version 12.0.
> Some psql features might not work.
> Type "help" for help.
>
>
I checked versions 13.1 and 12.3 and can confirm that in v13 a
password-included connection string still results in a prompt for a
password when using \connect, but it does not in 12.3.

David J.