Thread: Feature request: new column is_paused in pg_stat_replication

Hi hackers,

I don't know if it's possible or not, but could be interesting to add
a column in pg_stat_replication to now if the standby is paused. It
could be useful if
somebody has several standby servers and use this function for some tasks.

I know that there is an indirect way to calculate this in the primary,
just comparing
the other locations with the replay one.

Any toughs?


--
--
              Emanuel Calvo
              Helpame.com

On Wed, Jun 29, 2011 at 8:49 PM, Emanuel Calvo <postgres.arg@gmail.com> wrote:

> I don't know if it's possible or not, but could be interesting to add
> a column in pg_stat_replication to now if the standby is paused. It
> could be useful if
> somebody has several standby servers and use this function for some tasks.
>
> I know that there is an indirect way to calculate this in the primary,
> just comparing
> the other locations with the replay one.

Interesting thought, I'll look into it.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services