pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Johnathan Tiamoh <johnathantiamoh@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Need Help On Upgrade
Date: Mon, 10 Jul 2023 15:36:45 -0700
Message-ID: <26dd72fe-25f7-fe8d-b8f6-8ebfee651dbb@aklaver.com> (raw)
In-Reply-To: <CACoPQdbNWwzJ=njHFW2VAuvm7et=ezRoKKQziuOE_EPOSb=ZtQ@mail.gmail.com>
References: <CACoPQdb-goLOnE5Pjna=23872tBVONZ=xNqKD8ynv=44FRcSFA@mail.gmail.com>
	<b7c8a81e-552e-5aa3-0284-1c59c76d78ed@aklaver.com>
	<CACoPQdY1=BjA0DoxpKi1RiO2moqpF+c9NP3qyWnZDtMs4EZaeQ@mail.gmail.com>
	<b7291ed4-9a9a-05a7-9db8-d31d80835342@aklaver.com>
	<CACoPQdbNWwzJ=njHFW2VAuvm7et=ezRoKKQziuOE_EPOSb=ZtQ@mail.gmail.com>

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






view thread (16+ messages)  latest in thread

Message-ID: <26dd72fe-25f7-fe8d-b8f6-8ebfee651dbb@aklaver.com>
Permalink:  ../26dd72fe-25f7-fe8d-b8f6-8ebfee651dbb@aklaver.com/
Also on:    postgresql.org/message-id/26dd72fe-25f7-fe8d-b8f6-8ebfee651dbb@aklaver.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: adrian.klaver@aklaver.com, johnathantiamoh@gmail.com
  Subject: Re: Need Help On Upgrade
  In-Reply-To: <26dd72fe-25f7-fe8d-b8f6-8ebfee651dbb@aklaver.com>
  References: <CACoPQdb-goLOnE5Pjna=23872tBVONZ=xNqKD8ynv=44FRcSFA@mail.gmail.com> <b7c8a81e-552e-5aa3-0284-1c59c76d78ed@aklaver.com> <CACoPQdY1=BjA0DoxpKi1RiO2moqpF+c9NP3qyWnZDtMs4EZaeQ@mail.gmail.com> <b7291ed4-9a9a-05a7-9db8-d31d80835342@aklaver.com> <CACoPQdbNWwzJ=njHFW2VAuvm7et=ezRoKKQziuOE_EPOSb=ZtQ@mail.gmail.com> <26dd72fe-25f7-fe8d-b8f6-8ebfee651dbb@aklaver.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox