Re: Need Help On Upgrade

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>
>