"Ujwal S. Setlur" <[EMAIL PROTECTED]> writes: > --- Antonio Escudero <[EMAIL PROTECTED]> 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... -- "cbbrowne","@","ca.afilias.info" <http://dba2.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land) _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
