PostgreSQL configuration error

damthanhlong

Dear All
I configured as link PostgreSQL Database Monitoring (lpar2rrd.com)
I used postgreSQL 14 ver and I used GUI connect to postgreSQL error as below.
Anybody knows in this case?



Many thanks

damerva

Hello,
we recently encountered the same issue in our test labs. This is what helped:

Upgrade libpq on the application end and try again.

If you don't need scram-sha-256 authentication, you can revert to md5:

• set password_encryption = md5 in postgresql.conf
• change the authentication method to md5 in pg_hba_conf
• reload PostgreSQL
• change the password of the user to get an MD5 encrypted password
  

link: https://stackoverflow.com/questions/62807717/how-can-i-solve-postgresql-scram-authentifcation-problem

damthanhlong

Hello Damerva
Many thanks for your support.
Command
select passwd from pg_shadow where user='lpar2rrd';
select rolpassword from pg_authid where rolname ='lpar2rrd';
set password_encryption = md5;
alter user lpar2rrd password '****';
select rolpassword from pg_authid where rolname ='lpar2rrd';