Re: Upgrading using pg_dumpall

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.

Thanks again,

Rich