On Wed, 2005-08-03 at 00:30 +0300, Hannu Krosing wrote:
> On T, 2005-08-02 at 16:41 -0400, Rod Taylor wrote:
> > I'm not sure how it happened, but I currently have a synchronization
> > error within the data in a structure between 2 databases.
> > 
> > Out of approx. 1 million entries, the discrepancy includes 8000 tuples.
> >         
> >         Standard Slony 1.0.5
> >         Source DB is PostgreSQL 8.0.3
> >         Destination DB is PostgreSQL 7.4.6
> > 
> > There have been no errors in the the Slony log files. Replication is not
> > lagging (0 events behind in both directions), nor are there more than a
> > few hundred entries in the sl_log_1 structure.
> > 
> > Any thoughts before I reset these structures?
> 
> What do you mean by "structures" ? 

I intend to completely fry the Slony installation and start from
scratch.

It's obviously corrupted in some way or another.

> Do you have any tables with many triggers (before and after, changing
> tables back and forth) in your replicated set.

The only triggers are internal to PostgreSQL for foreign keys.

--