Mon Jan 9 14:29:30 PST 2006
- Previous message: [Slony1-general] How do I know when a subscriber has caught up?
- Next message: [Slony1-general] How do I know when a subscriber has caught up?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
--- Vivek Khera <vivek at khera.org> wrote: > > On Jan 9, 2006, at 4:39 PM, Ujwal S. Setlur wrote: > > > there a state change on the subscriber that I can > look > > at to determine that it has caught up? > > check the sl_status view on the master. Thank you. I guess I look at the st_lag_num_events field and wait for it to be 0 or close to it? Right now, that number is 6000 and climbing. I started the subscription about 6 hours ago. One of the tables is very large with ~50 million rows or more. Ujwal
- Previous message: [Slony1-general] How do I know when a subscriber has caught up?
- Next message: [Slony1-general] How do I know when a subscriber has caught up?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list