[pgpool-general: 6302] Re: Query regarding Health Check User and Streaming Replication Check user !
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.
> Nitish Kumar
SRA OSS, Inc. Japan
More information about the pgpool-general