From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Upgrading using pg_dumpall |
Date: | 2016-09-04 15:47:32 |
Message-ID: | e0d7fe59-33f3-a82c-32d8-63aa24522937@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 09/04/2016 08:14 AM, Rich Shepard wrote:
> On Sat, 3 Sep 2016, Adrian Klaver wrote:
>
>> Or if you are fine running the 9.5 instance at port 5432, what happens
>> if you do?:
>>
>> psql -d postgres -U some_user -p 5432
>
> $ psql -d postgres -U rshepard -p 5432
> Password for user rshepard: FATAL: password authentication failed for
> user "rshepard"
> DETAIL: User "rshepard" has no password assigned.
> Connection matched pg_hba.conf line 80: "local all all
> md5"
> psql: FATAL: password authentication failed for user "rshepard"
>
> but,
>
> $ psql -d postgres -U postgres -p 5432
> Password for user postgres: psql (9.5.4)
> Type "help" for help.
>
> postgres=#
>
> So, it appears to be a password issue. Please advise me how to get the
> running postmaster process to accept my accessing databases without a
> password being required.
Asked and answered. If you want the complete information:
https://www.postgresql.org/docs/9.5/static/client-authentication.html
>
> Thanks again,
>
> Rich
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2016-09-04 16:01:53 | Re: Upgrading using pg_dumpall [FIXED] |
Previous Message | Adrian Klaver | 2016-09-04 15:26:46 | Re: Upgrading using pg_dumpall |