David Lee Lambert dlambert at bmtcarhaul.com
Wed Aug 27 12:18:11 PDT 2008
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?  If it's 
stuck,  how do I unstick it?

-- 

David L. Lambert
  Software Developer,  Precision Motor Transport Group, LLC
  Work phone 517-349-3011 x215
  Cell phone 586-873-8813


More information about the Slony1-general mailing list