Mark Cave-Ayland wrote:
> Hmmmm. So even though PGPASSWORD is set (and the command works if the
> database exists within the cluster), if I specify a non-existent
> database then I still get prompted for a password.
Just to add a note to that - when running it in the same shell from
which I started the server with messages going to stdout, it seemed
clear that it trys to connect once using PGPASSWORD, then when that
fails, it prompts for the password instead, and then tries to connect
with that and fails a second time.
/D