monitoring bdr nodes
| От | Dennis | 
|---|---|
| Тема | monitoring bdr nodes | 
| Дата | |
| Msg-id | F38D1020-3B2C-41CF-BECD-1F1FB5B19806@visi.com обсуждение исходный текст | 
| Ответы | Re: monitoring bdr nodes | 
| Список | pgsql-general | 
I need some clarification on how to monitor BDR nodes.  In particular determining replication lag.  As an example,  I
havea two node cluster with nodes ‘A’ and ‘B’.    I need to be able to look at node ‘B’ and determine if it is lagging
behindnode ‘A’,  by interrogating node ‘B’ only.   
From the BDR documentation on monitoring:
SELECT pg_xlog_location_diff(pg_current_xlog_insert_location(), flush_location) AS lag_bytes,
       pid,
       application_name
  FROM pg_stat_replication;
Because it is querying the pg_stat_replication table,  I will need to run this query on node ‘A’ to check the lag on
node‘B’, is that true?  I need to be able run a query on node ‘B’ to determine if it node ‘B’ is behind.  I am not sure
theabove query will work for that use case. 
		
	В списке pgsql-general по дате отправления: