| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Johnathan Tiamoh <johnathantiamoh(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Need Help On Upgrade |
| Date: | 2023-07-10 22:36:45 |
| Message-ID: | 26dd72fe-25f7-fe8d-b8f6-8ebfee651dbb@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johnathan Tiamoh | 2023-07-11 00:38:17 | Re: Need Help On Upgrade |
| Previous Message | Bryn Llewellyn | 2023-07-10 21:17:46 | Re: Using "exit" to bring "goto" functionality. |