mle+tools@mega-nerd.com writes:
> Running the command:
> PGPASSFILE=pgpass psql --no-password --username myname mydb
> --command="\dt"
> works fine if the port number in the pgpass file is correct, but if the port
> number is incorrect the error message is:
> psql: fe_sendauth: no password supplied
> which is highly misleading. Surely the error message should be "connection
> refused" or some such?
I'm not sure how we could improve that. If the port number in the
password file doesn't match the intended connection, that means the
entry doesn't apply to this connection. We can hardly issue error
messages on the basis of the presence of unrelated entries in a
.pgpass file. So what the code is seeing is that the server demanded
a password (or so I'd assume), and it did not have one to give.
regards, tom lane
