Re: Upgrading using pg_dumpall
От | Rich Shepard |
---|---|
Тема | Re: Upgrading using pg_dumpall |
Дата | |
Msg-id | alpine.LNX.2.11.1609040812060.5431@localhost обсуждение исходный текст |
Ответ на | Re: Upgrading using pg_dumpall (Adrian Klaver <adrian.klaver@aklaver.com>) |
Ответы |
Re: Upgrading using pg_dumpall
Re: Upgrading using pg_dumpall |
Список | 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
В списке pgsql-general по дате отправления: