On Mar 28, 2006, at 10:49 AM, Dirk Jagdmann wrote: > Is there a better way (via SQL? or some slonik command?) to recognize > this event, than to read the syslog?
Query the sl_status view on the origin node's slony schema. When the number of events behind falls to zero, you're caught up. I don't think you can query when the initial copy is done other than looking at pg_stat_activity for the COPY statements to be gone. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
