From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Upgrading using pg_dumpall |
Date: | 2016-09-04 15:14:21 |
Message-ID: | alpine.LNX.2.11.1609040812060.5431@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Clavadetscher | 2016-09-04 15:14:39 | Re: Upgrading using pg_dumpall |
Previous Message | Rich Shepard | 2016-09-04 15:11:02 | Re: Upgrading using pg_dumpall |