[pgpool-general: 6253] Role & Privileges for Health Check User !
itcell.mpwz at mp.gov.in
Fri Oct 26 16:46:42 JST 2018
Just wanted to obtain clarification on the kind of ROLES & PRIVILEGES for the
We need to define these 2 users in pgpool.conf when using PgPool II in Master/Slave Streaming Mode.
I wanted to know what kind of user with what kind of different privileges should I create in my PostgreSQL Servers for enabling PgPool for proper functioning.
The sr_check_user uses which tables/functions/views for its functioning ?
The health_check_user uses which tables/functions/views for its functioning ?
Should giving a supersuser for these parameters a dangerous way or should I make a separate user with required roles & privileges just for these checks !
I wanted to make separate users for these checking parameters but I really don't know what kind of roles and privileges I needed to grant !
Kindly help by elaborating on above points.
Using PgPool II 3.7.5 and PostgreSQL 10.5 Servers.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general