Jim Ewert wrote:
> Christopher, I'm looking for how to determine on both the master &
> slave sides of slony1-1.0.1 if replication is active.  Thanks.
There are two scripts in the "tools" directory that are designed to do
an overall "cluster analysis."  One uses Perl DBI; the other uses Pg;
they both do the same things.

cbbrowne at dba2:~/Slony-I/slony1-HEAD-pristine> find . -name
"test_slony_state*.pl"                                         
Wednesday 14:24:06
./tools/test_slony_state-dbi.pl
./tools/test_slony_state.pl

Run one or the other against your cluster, and it will rummage through
and look for quite a number of problem conditions.

Over time, it has been growing somewhat tiresome asking people to run
one query or another to check the status of their replication clusters;
I'm getting convinced that the best first answer is to tell them to run
one of those scripts as that will find a number of common problems
fairly automatically...

If you simply want to know how up to date replication is, query the
contents of the view "sl_status" on the node that is the origin for your
favorite replication sets.  It will tell you how up to date the
subscribers are.