BUG #14156: Password Autehentication
The following bug has been logged on the website:
Bug reference: 14156
Logged by: Adnan Inayat
Email address: daniudass@hotmail.com
PostgreSQL version: 9.4.8
Operating system: Windows 8.1
Description:
I have recently installed PostgreeSql and try to run this command in Command
Line Interface(command prompt).
But it is demanding the password. I haven't set any password.
The password for super admin I have set, I tried to enter that password but
authentication fail. I am stuck...
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Wed, May 25, 2016 at 1:55 AM, <daniudass@hotmail.com> wrote:
I have recently installed PostgreSql and try to run this command in Command
Line Interface(command prompt).
But it is demanding the password. I haven't set any password.
The password for super admin I have set, I tried to enter that password but
authentication fail. I am stuck...
This is not a bug, but a general question for pgsql-novice or
pgsql-general. If it requests a password for you and you have an
access to the data folder, you could change pg_hba.conf from "md5" to
"trust", then run "pg_ctl reload" or restart the server, and finally
you'll be able to connect without a password.
You may want to check as well if you don't have a PGPASS file, this
depends on how you installed Postgres, and you are providing no
details regarding that, so we are limited to guesses here.
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs