Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

psql.exe after new installation

25 views
Skip to first unread message

jim....@branr.com

unread,
Aug 6, 2019, 5:35:45 PM8/6/19
to
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

jim....@branr.com

unread,
Aug 7, 2019, 12:54:20 PM8/7/19
to
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

Matthew Woodcraft

unread,
Aug 7, 2019, 1:02:35 PM8/7/19
to
In article <23107516-8be5-4c83...@googlegroups.com>,
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-

0 new messages