[pgpool-general: 2104] Re: sr_check_user permissions

Tatsuo Ishii ishii at postgresql.org
Wed Sep 4 11:01:44 JST 2013

> Hey,
> What would be the best permissions to give this user in postgres, I'm
> guessing the user needs to be able to run pg_stat_replication which would
> mean it needs to be a superuser ?

No. Pgpool-II calls pg_current_xlog_location() or
pg_last_xlog_replay_location() as sr_check_user and these functions do
not require superuser privilege.
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

More information about the pgpool-general mailing list