Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: BUG #16746: [PG12.5 psql] Password ignored by connect meta-command
Date
Msg-id CAKFQuwagfZ_KG-PbuTqCgKWOjELfDRLZrCvDiBSpZZqNgigK4Q@mail.gmail.com
Whole thread Raw
In response to BUG #16746: [PG12.5 psql] Password ignored by connect meta-command  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16746: [PG12.5 psql] Password ignored by connect meta-command
List pgsql-bugs
Tree view
Tom, will need your input here.

On Thu, Nov 26, 2020 at 4:09 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16746
Logged by:          Krzysztof Gradek
Email address:      kgradekx@gmail.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@127.0.0.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.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: SV: Problem with pg_notify / listen
Next
From: Tom Lane
Date:
Subject: Re: BUG #16746: [PG12.5 psql] Password ignored by connect meta-command