[pgpool-general: 6302] Re: Query regarding Health Check User and Streaming Replication Check user !

Tatsuo Ishii ishii at sraoss.co.jp
Wed Nov 21 22:28:22 JST 2018

> Hi All,
> I wanted to know that how pgpool II checks for Streaming replication delays and other checks through sr_check_user
> when the sr_check_user have just CONNECT privileges to the Database.

If a role has CONNECT privileges, it can login to a database and
execute function (if granted to public). sr_check_user want to execute
some builtin-functions, such as pg_is_in_recoery, which is granted to

> In the same way how come PgPool II performs health checkups using health_check_user when the health_check_user
> have just CONNECT privileges to the Database.


> I have made two users for sr_check_user and health_check_user and granted only CONNECT and LOGIN privileges to
> the database.
> Does these two users require more wider PRIVILEGES or my configurations are correct ?


> Can someone explain or am I doing something incorrect.
> Regards,
> Nitish Kumar

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list