David,
I've tried running that script. The first time I tried, I got an error
trying to find Pg.pm. I had to modify the use statement to include
DBD::Pg. Now I'm getting errors at lines 46 and 56, something like the
following:

Bareword "PGRES_CONNECTION_OK" not allowed while "strict subs" in use
at...

I also get it on "PGRES_TUPLES_OK". The script then aborts due to
compilation errors. I'm not much of a perl programmer, so I'm not sure
what the problem is.

Doug

-----Original Message-----
From: David Rees [mailto:drees76 at gmail.com] 
Sent: Monday, September 22, 2008 4:47 PM
To: Knight, Doug; slony1-general at lists.slony.info
Subject: Re: [Slony1-general] How to determine when the target has
caught up to the origin

On Mon, Sep 22, 2008 at 12:45 PM, Knight, Doug <dknight at wsi.com> wrote:
> I am running a pair of servers, origin copying to target, slony
version
> 1.2.14 on CentOS 5.2. I've got my slony replication working, and now I
need
> to know an easy way to determine when the target is caught up.

http://slony.info/documentation/monitoring.html#TESTSLONYSTATE

Also look at the sl_status view.

-Dave