Re: Upgrading using pg_dumpall

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.klaver@aklaver.com