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

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: sys-milan(at)statpro(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #9136: pg_is_xlog_replay_paused() should not need Superuser
Date: 2014-04-18 15:47:35
Message-ID: CAJghg4+H1hCve6OMNs7Xnbx8w-tv_HsHjr8Ofs-6+eUrd+RmqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Feb 7, 2014 at 8:16 AM, <sys-milan(at)statpro(dot)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,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ludovic POLLET 2014-04-18 16:14:50 Re: BUG #8842: lo_open/fastpath transaction inconsistency
Previous Message fburgess 2014-04-18 15:24:52 Re: Having trouble configuring a Master with multiple standby Servers in PostgreSQL 9.3.3