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