관리 메뉴

팀드모네 IT Blog

[Solved] Postgresql SCRAM authentifcation 본문

카테고리 없음

[Solved] Postgresql SCRAM authentifcation

남명 팀드모네 2021. 8. 22. 19:27

[solution]

You can change the postgresql configuration to md5.

 

[Workaround]

1. pg_hba_conf

cd C:\Program Files\PostgreSQL\13\data\pg_hba_conf

Change the method from scram-sha-256 to md5

 

2. postgresql.conf

cd C:\Program Files\PostgreSQL\13\data\postgresql.conf

Change the password_encryption from scram-sha-256 to md5

3. reload PostgreSQL

4. change the password of the user to get an MD5 encrypted password

 

good luck!

0 Comments
댓글쓰기 폼