1. Forum
  2. Usenet
  3. COMP.DATABASES.POSTGRESQL

  • psql.exe after new installation

    From jim.brown@branr.com@21:1/5 to All on Tue Aug 6 14:35:45 2019
    I've installed postgresql 11 from postgresql-11.4-2-windows-x64.exe from https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=1256714. Worked great.

    If I open psql, it prompts with: "Password for user jimbr:"

    jimbr is my windows account name so this is not unreasonable. However, no matter what I supply as password, the window just closes. I tried postgres, the master password I set up during installation, my windows logon password and empty. The window just
    closes.

    Any ideas?

    Jim

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From jim.brown@branr.com@21:1/5 to All on Wed Aug 7 09:54:19 2019
    Just to close this out.

    I decided to switch to trusted connections and updated pg_hba.conf to

    local all all trust
    # IPv4 local connections:
    host all all 127.0.0.1/32 trust
    # IPv6 local connections:
    host all all ::1/128 trust

    Now psql.exe comes up and immediatly crashes without prompting for a password.

    I'll give up on psql

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Matthew Woodcraft@21:1/5 to jim.brown@branr.com on Wed Aug 7 18:02:33 2019
    In article <23107516-8be5-4c83-a14b-38d8fe680eb9@googlegroups.com>,
    <jim.brown@branr.com> wrote:
    I've installed postgresql 11 from postgresql-11.4-2-windows-x64.exe from >https://www.enterprisedb.com/thank-you-downloading-postgresql?anid=1256714. >Worked great.

    If I open psql, it prompts with: "Password for user jimbr:"

    jimbr is my windows account name so this is not unreasonable. However, no >matter what I supply as password, the window just closes. I tried
    postgres, the master password I set up during installation, my windows
    logon password and empty. The window just closes.

    Any ideas?

    You need to tell psql to connect as a user that's in PostgreSQL's list
    of users. If you've just installed it that's probably only the
    'postgres' user.

    So try passing --username=postgres on the psql command line.

    -M-

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)