I have a strange behavior with psql on Windows. Let's describe : on a Postgres server under linux, a user has been created (by error) with uppercases. The connection works on server command line, but not with psql on a Windows machine.
On the Postgres server, on command line, the connection works fine :
psql -U myUSER -W -d mydb
mydb#
But, if I do the same on a Win11 with psql installed, I can't connect :
"C:\Program Files\PostgreSQL\16\bin"\psql -qAt -F '' -h myPGserver -U myUSER -W -d mydb -p 5432
psql: error: connection to server at "myPGserver" (192.xxx.xx.xx), port 5432 failed: FATAL: password authentication failed for user "myUSER"
I'm, of course, absolutely sure that I give the right password, like on the linux command line. And the PC is allowed in pg_hba, or this would not be the same error. I'm lost ... Any brilliant idea ? Thanks