--- Christopher Browne <cbbrowne at ca.afilias.info>
wrote:

> "Ujwal S. Setlur" <uvsetlur at yahoo.com> writes:
> > --- Antonio Escudero <aescudero at rocketmail.com>
> wrote:
> >> 1. I know now that slony is working, but i still
> >> want to know on how long will it take to finish
> >> replicating a large database?
> >>
> >
> > Check the _<cluster_name>.sl_status view on the
> origin
> > of the subscribed set. I generally look at the
> > num_lag_events field. Once the subscriber has
> caught
> > up, that number should be close to zero.
> 
> Well, while it's processing the SUBSCRIBE_SET event,
> that lag will
> steadily grow until it actually finishes copying all
> the data.
> 
> sl_status won't be of much interest during that
> time...

Yup, understood. But after the subscription, it should
start giving some real feedback.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com