In response to David Lee Lambert <dlambert at bmtcarhaul.com>:

> Yesterday afternoon I installed Slony 1.2.10 against Postgres 8.0 on a Gentoo 
> box,  and set up two pgbench databases with it,  "pgbench_master" 
> and "pgbench_slave".  With the two "slon" processes running, I 
> ran "pgbench -i" and "pgbench" from another host.  As of right now,  the data 
> still isn't replicated:
> 
>  pgbench_master=# SELECT aid,bid,abalance FROM accounts ORDER BY abalance DESC 
> LIMIT 10;
>    aid   | bid | abalance 
> ---------+-----+----------
>  1541195 |  16 |      938
>  1131104 |  12 |      929
>   230915 |   3 |      906
> ...
> pgbench_slave=#  SELECT aid,bid,abalance FROM accounts ORDER BY abalance DESC 
> LIMIT 10;
>   aid  | bid | abalance 
> -------+-----+----------
>  29533 |   1 |     1747
>  23957 |   1 |     1704
>  99989 |   1 |     1624
> ...
> 
> The system is a single-CPU Pentium 4 2.8GHz with 1G of RAM, not running any 
> other active applications.  Is this sort of delay normal with Slony?

Not unless your network is unbelievably slow.

> If it's 
> stuck,  how do I unstick it?

Have a look at the log files.  Slony is pretty good about logging why
it's unable to replicate.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran at collaborativefusion.com
Phone: 412-422-3463x4023