[pgpool-general: 9078] Re: Pgpoo-II with non-superuser account.

[Bo Peng]

Hi,
 
> We are seeking advice if it is possible to execute pgpool_recovery 
> function with non-superuser account.

No. Superuser privilege is required to run pgpool_recovery.

The superuser privilege is checked in pgpool_recovery function.
An error will be returned if fails.

> If this is possible, will appreciate on guidance on how to setup it up.
> 
> Our end has tried to grant execute on function to pgpool_recovery to the 
> user, but still no successful.


-- 
Bo Peng <pengbo at sraoss.co.jp>