Re: BUG #14156: Password Autehentication

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