| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | daniudass(at)hotmail(dot)com |
| Cc: | PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #14156: Password Autehentication |
| Date: | 2016-05-25 16:29:50 |
| Message-ID: | CAB7nPqQ88LaaHxqck2LWNoytkgwkdf0P9+etf4xKGnVbo3Wuxw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, May 25, 2016 at 1:55 AM, <daniudass(at)hotmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2016-05-25 16:38:05 | Re: Too high rate of progress information from pg_basebackup |
| Previous Message | Michael Paquier | 2016-05-25 16:02:03 | Re: BUG #14158: PostgreSQL 9.6 bloom don't support unlogged table? |