Authentication : Password passed part of connection string parameters is not considered with PostgresSql 13.1

Question

recently we have upgraded our postgres db to version 13.1. after that we are facing strange behaviour with Connection Strings

with PostgresSql 12.3 below command used to connect successfully to DB with out prompting for password

**postgres=# \connect "dbname=dm_test_db4_db user=test_db4 host=localhost port=5432 password=password";
You are now connected to database "dm_test_db4_db" as user "test_db4".*

with PostgresSql 13.1 input for password prompted and if we provide password connection is successful.

*postgres=# \connect "dbname=dm_test_db4_db user=test_db4 host=localhost port=5432 password=password";
Password for user test_db4:
You are now connected to database "dm_test_db4_db" as user "test_db4".*

since these command is part of a sql script no input is given , script is failing with Authentication failure.

Here are my env details

postgres version details: C:\Program Files\PostgreSQL\13\bin>postgres.exe -V postgres (PostgreSQL) 13.1 OS:Windows

these are the settings in pg_hba.conf

 - IPv4 local connections:

host    all             all             127.0.0.1/32            md5

 - IPv6 local connections:

host    all             all             ::1/128                 md5

Any idea what is causing this behavior?

Answer 1

There is a bug in the 13.1 version of psql (the client program, not the database server). It was fixed in 13.2