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" <[EMAIL PROTECTED]> 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 > [email protected] > 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 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
