Feature request: new column is_paused in pg_stat_replication

Started by Emanuel Calvoover 14 years ago2 messages
#1Emanuel Calvo
postgres.arg@gmail.com

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

#2Simon Riggs
simon@2ndQuadrant.com
In reply to: Emanuel Calvo (#1)
Re: Feature request: new column is_paused in pg_stat_replication

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