Melvin Davidson mdavidson
Thu Oct 26 07:29:35 PDT 2006
>If there is any possiblity to check if master node died??
>Because error just shows when node was removed, and not when thread was
killed...or even postmaster was 
>killed :(

To check is slon is still alive on ANY node
ps -ef | grep slon

If you see the slon process, then  it's alive.

If postmaster dies, then slon dies also.


>Second question:

>Likewise to verify when a slave has successfully finished subscribing:
>grep copy slon1.log

Did you subscribe the node? If show, the you should see copy.

>The word copy never appeared in my log file :( even my whole
replications works really fine.. Have no idea
>where problem can be.. I even increase debug nuber and still nothing.
>So does it work in your case?? Or maybe other idea how to check when
both databases are identical? 

Another way to check is if the _your_rep_schema.sl_table &
_your_rep_schema.sl_sequence tables on the slave node(s) have all the
tablls they are supposed to be subscribed to.

Also, check the values of st_lag_num_events & st_lag_time.

You should not have more than a one st_lag_num_events & st_lag_time
should be less than 10 sec.
Otherwsie there is a delay in your network



More information about the Slony1-general mailing list