Unanswered: running pgsql.exe from where it is installed
I installed PosgtreSQL in Windows 7 using the One-click-installer.
That gave me a shortcut to the SQL Shell(psql). Clicking on the shortcut runs the shell, and it works OK.
However, when I go to the file C:\Program Files (x86)\PostgreSQL\9.1\bin\psql.exe, and I click on it, the shell comes up asking directly for a password. I give the postgres password, and the shell closes with a message of failed authentication.
I wonder why that is so. Can someone please clear me on that?
I would assume because of: a message of failed authentication..
If you enter wrong credentials, psql exits and therefor the commandline window is also closed.
I am quite certain that I have typed the correct p.w. for the postgres user. I have even typed it in a text editor and pasted it, both to the screen that comes up when I click on the .exe and on the shell that the installed short cut provides.
By pasting, the installation shortcut works, while the shell rendered by clicking directly on the .exe always yields the failed authentication message.
Should that not, then be happening, from reading your reply?