pgpool添加用户

1.pgpool添加用户

cd /etc/pgpool-II

vi pool_passwd

2.执行sql语句,获取md5

select rolname,rolpassword from pg_authid

vi pool_passwd

    appforpacer:md5e72cd3feac7ea1a6b372aa8a5fec0a7f

3.重新启动pgpool

ps -ef | grep pgpool | grep -v grep  | awk '{system("kill -9 " $2)}';

rm -f /tmp/.s.PGSQL.9999 /tmp/.s.PGSQL.9898

pgpool

1)启动失败,10.100.2.89被占用

    ifconfig etho0:0 down

    pgpool

4.重新加载配置文件

pgpool [-c][-f config_file][-a hba_file][-F pcp_config_file] reload

pgpool -F pool_passwd reload

来源张永光的博客