From: | john(dot)reilly(at)tetraireland(dot)ie |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #12461: Incorrect PSQL User Login in Windows |
Date: | 2015-01-08 14:10:57 |
Message-ID: | 20150108141057.11501.47797@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 12461
Logged by: John Reilly
Email address: john(dot)reilly(at)tetraireland(dot)ie
PostgreSQL version: 9.4.0
Operating system: Windows 7
Description:
I did a complete installation from the internet 2 days ago. I first used
pgAdminIII to administer the DB and try out features. I then looked at the
tutorial on this site and found that I needed to use PSQL. Once I tried to
start it, I found that I was being rejected because of invalid Password.
Eventually I realised that the PSQL default USER that was being rejected was
my computer User Name and NOT the ONLY registered user in PostgreSQL (user -
postgres). The documentation is confusing in this area as changes have been
made recently.
I then used the '-U postgres' option and all went OK. This is VERY
confusing and needs to be better documented or simplified.
I now can log in without using a password, because that is the way it was
set up in pgAdminIII which may be unintentional (use of the pgpass.conf file
is shared) - for information only.
PS - don't forget pgAdminIII is now included in the PostgreSQL installer, so
that people may go there first for ease of use initially.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-01-08 15:14:53 | Re: BUG #12458: Comparison with CHAR is inconsistent between string types |
Previous Message | Amit Langote | 2015-01-08 08:07:38 | Re: BUG #12458: Comparison with CHAR is inconsistent between string types |