Dmitry Koterov dmitry at koterov.ru
Wed May 16 03:57:38 PDT 2007
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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070516/=
22ec0e4c/attachment.htm


More information about the Slony1-general mailing list