On Thu, Jan 19, 2012 at 7:04 PM, Alexander Fortin
wrote:
> thank you very much for your suggestion. In the meanwhile we went for a
> check on pg_stat_replication, but we'll add one as you suggest soon on the
> replicas.
You are welcome.
> By the way, maybe you know where I could find documentati
On 1/18/12 9:38 AM, Sergey Konoplev wrote:
With 9.1 you can use
SELECT now() - pg_last_xact_replay_timestamp() AS time_lag;
Hi Sergey,
thank you very much for your suggestion. In the meanwhile we went for a
check on pg_stat_replication, but we'll add one as you suggest soon on
the replicas.
Hi,
On Mon, Jan 16, 2012 at 1:25 PM, Alexander Fortin
wrote:
> Anyway, the whole idea is to check "distance" between the actual value for
> the master (still have to figure out where is that) and the replicas
> replay_location, and alert if that value is too high compared to our average
> trends.
