No password supplied when trying to switch db using .pgpass file

[zoiman]

Description

I am using an alias_dsn and a .pgpass The alias looks like this:

mydb= 'postgresql://postgres@mydbcluster:5432/myInitialDB'

and the corresponding part in the .pgpass file looks like this:

mydbcluster:5432:myInitialDB:password

I can connect without entering the password with the alias, but when I try to switch the db via \connect otherDB I get the following error:

connection failed: connection to server at "someIP", port 5432 failed: fe_sendauth: no password supplied

Your environment

• [x] Please provide your OS and version information. macos 14.6.1
• [x] Please provide your CLI version. Version: 4.1.0

[zoiman]

sorry my bad, the solution is to just supply the same entry in .pgpass file for each db.