Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #9136: pg_is_xlog_replay_paused() should not need Superuser - Mailing list pgsql-bugs

From Matheus de Oliveira
Subject Re: BUG #9136: pg_is_xlog_replay_paused() should not need Superuser
Date
Msg-id CAJghg4+H1hCve6OMNs7Xnbx8w-tv_HsHjr8Ofs-6+eUrd+RmqQ@mail.gmail.com
Whole thread Raw
In response to BUG #9136: pg_is_xlog_replay_paused() should not need Superuser  (sys-milan@statpro.com)
List pgsql-bugs
Tree view 
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 by date:

Previous
From:
Date:
Subject: Re: Having trouble configuring a Master with multiple standby Servers in PostgreSQL 9.3.3
Next
From:
Date:
Subject: Re: Having trouble configuring a Master with multiple standby Servers in PostgreSQL 9.3.3