Thu Oct 26 07:29:35 PDT 2006
- Previous message: [Slony1-general] Small Slony monitoring GUI
- Next message: [Slony1-general] Hi drop or delete a Cluster by console
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
>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
- Previous message: [Slony1-general] Small Slony monitoring GUI
- Next message: [Slony1-general] Hi drop or delete a Cluster by console
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list