"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...
-- 
"cbbrowne","@","ca.afilias.info"
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)