Re: BUG #9136: pg_is_xlog_replay_paused() should not need Superuser

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: BUG #9136: pg_is_xlog_replay_paused() should not need Superuser
Дата
Msg-id CAJghg4+H1hCve6OMNs7Xnbx8w-tv_HsHjr8Ofs-6+eUrd+RmqQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #9136: pg_is_xlog_replay_paused() should not need Superuser  (sys-milan@statpro.com)
Список pgsql-bugs
Дерево обсуждения 
On Fri, Feb 7, 2014 at 8:16 AM, <sys-milan@statpro.com> wrote:

> The admin function pg_is_xlog_replay_paused() is read only and can be
> useful
> for monitoring, as such it should NOT require superuser privileges (as it
> does now).
>

Just as an workaround for this situation, you can create a function with
SECURITY DEFINER that wraps the call of pg_is_xlog_replay_paused.

Best regards,
--=20
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br n=C3=ADvel F!
www.dextra.com.br/postgres

В списке pgsql-bugs по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: Having trouble configuring a Master with multiple standby Servers in PostgreSQL 9.3.3
Следующее
От:
Дата:
Сообщение: Re: Having trouble configuring a Master with multiple standby Servers in PostgreSQL 9.3.3