Re: Need Help On Upgrade

Поиск
Список
Период
Сортировка
От Johnathan Tiamoh
Тема Re: Need Help On Upgrade
Дата
Msg-id CACoPQdZ9NE65Rpr=aCm+vWD56QuS-rkPiv0ZO4ZcbSJOU9MiiA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need Help On Upgrade  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Need Help On Upgrade  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Дерево обсуждения
Sorry Adrian,

Below is the full error message.

2023-06-27 05:01:27.385 CDT| XXXXXXXXXXXXXXXXXXXXXXX (60930)| APPNAME=[unknown]| DB=postgres| USER=grafana| PID=9061| 1| authentication| PGE-28P01: FATAL:  password authentication failed for user "grafana"
2023-06-27 05:01:27.385 CDT| XXXXXXXXXXXXXXXXXXXXXXX (60930)| APPNAME=[unknown]| DB=postgres| USER=grafana| PID=9061| 2| authentication| PGE-28P01: DETAIL:  Connection matched pg_hba.conf line 113: "host    all         all         0.0.0.0/0             md5"

On Mon, Jul 10, 2023 at 6:36 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 7/10/23 13:20, Johnathan Tiamoh wrote:
>
>> Ok Adrian,
>>
>> Postgres 9.5
>>
>>      postgresql.conf
>>
>>         password_encryption  = ?  md5  ====> wish is the default for 9.5
>>
>>      pg_hba.conf    -----------------> md5
>>
>>          Provide the relevant lines
>>
>> Postgres 14.8
>>
>>      postgresql.conf
>>
>>         password_encryption  = ?   scram-sha-256  ====> which is the
>> default for 14.8
>>
>>      pg_hba.conf      md5
>
> You have not answered:
>
> 2) Provide the error messages received when trying to connect.
> [XXXXXXXXXXXXXXXXXXXXXXX| APPNAME=[unknown]| DB=proftpd| USER=proftpd|
> PID=9053| 2| authentication| PGE-28P01: DETAIL:  Connection matched
> pg_hba.conf line 113: "host    all         all 0.0.0.0/0
> <http://0.0.0.0/0>             md5"
>

The above is not showing any actual error. There should a part that says
what failed when connecting.


--
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Need Help On Upgrade
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"