Ujwal S. Setlur wrote: > > --- 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.
being on topic, is there a way to verify that replication is consistent on 2 nodes. i had a problem today with inconsistencies in a replica - there were no errors in the log files, but certain records were missing on one of the slaves. afaik there was no network disconnection. cheers, l _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
