Vivek Khera vivek
Tue Mar 28 08:11:35 PST 2006
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.




More information about the Slony1-general mailing list