开发者

What permissions does the health_check_user for pgpool-II need?

开发者 https://www.devze.com 2023-04-02 16:47 出处:网络
I\'m confused about a point of pg_pool-II\'s documentation. The health_check_user is used to determine the health of DB cluster servers, but what abilities does the health_check_user need? As there ar

I'm confused about a point of pg_pool-II's documentation. The health_check_user is used to determine the health of DB cluster servers, but what abilities does the health_check_user need? As there are no configuration options to开发者_Go百科 get a password for this user, I'm assuming that pg-pool's health_check_user will likewise need trust level access to each DB?


It looks like it just needs permission to connect to the databases (same username for all databases).

You don't need to rely on trust auth either, I'm sure you can use a .pgpass file. http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html


As Richard said, it only needs to connect to the database.

And also you can set password for this user with health_check_password

0

精彩评论

暂无评论...
验证码 换一张
取 消