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

[Tatsuo Ishii]

> 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
public.

> 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.

Ditto.

> 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 ?

No.

> 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
Japanese:http://www.sraoss.co.jp