Ujwal S. Setlur uvsetlur
Tue Jan 17 14:06:03 PST 2006
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 



More information about the Slony1-general mailing list