Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    18

    Unanswered: running pgsql.exe from where it is installed

    Hi everyone,

    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?

    Thanks.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Quote Originally Posted by elmug View Post
    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.

  3. #3
    Join Date
    Jun 2012
    Posts
    18
    Quote Originally Posted by shammat View Post
    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.
    Hi shammat,

    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?

    Thanks.
    Last edited by elmug; 06-14-12 at 17:11.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •