How to Configure SCRAM and MD5 Authentication in Pgpool-II
This post refers to my previous one Authentication in Pgpool-II . In the post I introduced how Pgpool-II authentication mechanism works. In this post I will describe how to configure SCRAM and MD5 authentication methods in details. scram-sha-256 Authentication Configuration To perform the password-based authentication, Pgpool-II requires a password file which contains a list of database users and passwords in format username:password . The default password file name is pool_passwd . If scram-sha-256 is specified as the authentication method in pool_hba.conf or pg_hba.conf , to use scram-sha-256 authentication, the decryption key to decrypt the passwords is required. We create the .pgpoolkey file in the home directory of Pgpool-II start user. Here we assume that Pgpool-II is started using postgres user. # su - postgres $ echo 'some string' > ~/.pgpoolkey $ chmod 600 ~/.pgpoolkey Assuming you've already created a database user pgpool . Execute the pg_enc to reg...