PostgreSQL configuration error
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](https://forum.xorux.com/uploads/editor/v7/ie2zas3uu7nh.png)
![Image: https://forum.xorux.com/uploads/editor/6u/rz6ihprzitm7.png](https://forum.xorux.com/uploads/editor/6u/rz6ihprzitm7.png)
![Image: https://forum.xorux.com/uploads/editor/42/fqeef18mp1nd.png](https://forum.xorux.com/uploads/editor/42/fqeef18mp1nd.png)
Many thanks
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](https://forum.xorux.com/uploads/editor/v7/ie2zas3uu7nh.png)
![Image: https://forum.xorux.com/uploads/editor/6u/rz6ihprzitm7.png](https://forum.xorux.com/uploads/editor/6u/rz6ihprzitm7.png)
![Image: https://forum.xorux.com/uploads/editor/42/fqeef18mp1nd.png](https://forum.xorux.com/uploads/editor/42/fqeef18mp1nd.png)
Many thanks
Comments
-
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 tomd5
:- set
password_encryption = md5
inpostgresql.conf
- change the authentication method to
md5
inpg_hba_conf
- reload PostgreSQL
- change the password of the user to get an MD5 encrypted password
- set
-
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';
Howdy, Stranger!
Categories
- 1.5K All Categories
- 24 XORMON NG
- 25 XORMON
- 139 LPAR2RRD
- 12 VMware
- 14 IBM i
- 2 oVirt / RHV
- 4 MS Windows and Hyper-V
- Solaris / OracleVM
- XenServer / Citrix
- Nutanix
- 6 Database
- 2 Cloud
- 10 Kubernetes / OpenShift / Docker
- 118 STOR2RRD
- 18 SAN
- 7 LAN
- 17 IBM
- 3 EMC
- 11 Hitachi
- 5 NetApp
- 15 HPE
- Lenovo
- 1 Huawei
- 1 Dell
- Fujitsu
- 2 DataCore
- INFINIDAT
- 3 Pure Storage
- Oracle