Wed May 16 04:21:03 PDT 2007
- Previous message: [Slony1-general] How to determine if the slave is up to date?
- Next message: [Slony1-general] How to determine if the slave is up to date?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] How to determine if the slave is up to date?
- Next message: [Slony1-general] How to determine if the slave is up to date?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list