"Dmitry Koterov" <dmitry at koterov.ru> writes:
> Hello.
> Is it possible to determine that a slave has up-to-date status according to the master's status at some time?
> E.g. I want to post some update to the master at the moment A, remember its "up-to-date counter" and a second or two later (moment B) - check if the slave has greater
> or equal value of this counter. If so, I suppose than at the moment B slave is "up-to-date" relative to the master at the moment A.
> In previous Slony version I could use "select last_value from "_moikrug_cluster".sl_log_status" to fetch such counter from the master, but in the recent Slony version
> this counter seems to be always zero.
> I understant that I could implement this functionality manually (create a sequence and increment it on the master with later checking at the slave), but possibly Slony
> has already such sequence implemented?

Look at the view "sl_status", on the origin node for a given set.

The view lists what has been confirmed by all the other nodes, and
even includes a count of how many events each subscriber is behind.
-- 
output = ("cbbrowne" "@" "ca.afilias.info")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)