生成pgpool.conf中的pool_passwd参数所需要的文件

有以下4种方法生成pgpool.conf中的pool_passwd参数所需要的文件.

• 1和2采用md5加密密码,区别只是是否从文件创建
• 3和4采用scram加密密码,区别只是是否从文件创建
• 自Pgpool-II 4.0起支持scram-sha-256、证书和明文密码

1 md5

su - postgres

sudo rm /usr/local/pgpool/etc/pool_passwd
sudo pg_md5 -m -f /usr/local/pgpool/etc/pgpool.conf -u test -p

cat /etc/pgpool-II/pool_passwd

2 md5从文件创建

su - postgres

#生成用户文件
echo 'test:123' > ~/users.txt
cat ~/users.txt

sudo rm /usr/local/pgpool/etc/pool_passwd
sudo /usr/local/pgpool/bin/pg_md5 -m -f /usr/local/pgpool/etc/pgpool.conf -i ~/users.txt

cat /usr/local/pgpool/etc/pool_passwd

3 scram-sha-256

su - postgres

#将pgpoolkey保存至 ~/.pgpoolkey
echo '123' > ~/.pgpoolkey
chmod 600 ~/.pgpoolkey 

sudo rm /usr/local/pgpool/etc/pool_passwd
sudo /usr/local/pgpool/bin/pg_enc -m -k ~/.pgpoolkey -u test -p

cat /usr/local/pgpool/etc/pool_passwd

4 scram-sha-256从文件创建

自Pgpool-II 4.0起支持scram-sha-256、证书和明文密码

su postgres

#将pgpoolkey保存至 ~/.pgpoolkey
echo '123' > ~/.pgpoolkey
chmod 600 ~/.pgpoolkey 

#生成用户文件
echo 'test:123' > ~/users.txt
cat ~/users.txt

sudo rm /usr/local/pgpool/etc/pool_passwd
sudo /usr/local/pgpool/bin/pg_enc -m -k ~/.pgpoolkey -f /usr/local/pgpool/etc/pgpool.conf -i ~/users.txt

cat /usr/local/pgpool/etc/pool_passwd