Dmitry Koterov dmitry at koterov.ru
Wed May 16 04:21:03 PDT 2007
Oh, I suppose that this counter is the number of last processed/generated
SYNC event.
So, POSSIBLY the question is:
1. how to determine the last SYNC number generated by the master?
2. how th determine the last SYNC number processed by the slave?

On 5/16/07, Dmitry Koterov <dmitry at koterov.ru> wrote:
>
> 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/=
07d605cb/attachment.htm


More information about the Slony1-general mailing list