Bill Moran wmoran at collaborativefusion.com
Mon Feb 11 12:51:36 PST 2008
In response to Geoffrey <lists at serioustechnology.com>:

> We've found where we are getting a partial replication of a set.  That 
> is to say, about half the tables in the set are being replicated and the 
> rest are not.  It's like the set was partially processed.  We see the 
> first 15 tables in the set replicated, but any tables after those are 
> not.  Further, none of the sequences defined in that set are being 
> replicated.  It's like it got to a table in the set and ignored 
> everything after that.
> 
> Is there max limit on the number of tables in a set?  It appears the set 
> stopped at 30 table entries.

I can assure you that you can replicate over 30 tables.  We have ~150
in one of our databases.

What's in the logs?  Is it possible that Slony is hung up on some sort
of error or other problem on one of those tables?  If you look at
sl_table, are all the tables listed?  What does the sl_status view
say?

Did this do the initial sync and then stop syncing, or did it fail to
do the initial sync?  What kind of activity is on the server: are the
slons doing anything at all?

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

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


More information about the Slony1-general mailing list