PostgreSQL configuration error

damthanhlong · March 2022

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?

Image: https://forum.xorux.com/uploads/editor/v7/ie2zas3uu7nh.png

Image: https://forum.xorux.com/uploads/editor/6u/rz6ihprzitm7.png

Image: https://forum.xorux.com/uploads/editor/42/fqeef18mp1nd.png

Many thanks

damerva · March 2022

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 · March 2022

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';

PostgreSQL configuration error

Comments

Howdy, Stranger!

Categories

In this Discussion