Tue Jan 17 14:06:03 PST 2006
- Previous message: [Slony1-general] Problems catching up?
- Next message: [Slony1-general] Problems catching up?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, Does anyone have an idea about what might be going wrong and how I might be able to fix it short of dropping the slave node and re-subscribing? Thanks, Ujwal --- "Ujwal S. Setlur" <uvsetlur at yahoo.com> wrote: > Hi all, > > So I have this master/slave setup with replication > going. One particular table is huge, ~50 million > rows. > It took about 24 hours for the slave to subscribe > and > catch up. But it did: st_num_lag_events came to 0. > > Then the master got rebooted for some reason. Slony1 > was not in the startup scripts so it did not get > launched for a day or so. I started it manually and > expected the slave to catch up eventually. It > hasn't. > It has been about 4 days. st_num_lag_events is about > 64000 and growing. > > Any ideas? > > Thanks, > > Ujwal > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > _______________________________________________ > Slony1-general mailing list > Slony1-general at gborg.postgresql.org > http://gborg.postgresql.org/mailman/listinfo/slony1-general > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
- Previous message: [Slony1-general] Problems catching up?
- Next message: [Slony1-general] Problems catching up?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list