Search Postgresql Archives

Re: Need Help On Upgrade

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux