"Talha Khan" <[EMAIL PROTECTED]> writes: > Guyz!! > > > > I have implemented slony1 replication with postgres 8.1.2 . The problem that > is happening with my replication is that my sl_log_1 file is constantly > growing without > any cleanup going on. Replication is taking place without any problem. > > > > Ive seen on the archives and it seems a very common problem but ive tried all > the remedies but nothing worked > > > > Ive checked for any idle transaction ---- which were none > > > > i guesss theres something wrong with my sl_event table cause its not being > updated properly. > > > > My cleanup thread always checks for the same xids that have already been > synced
Run the script in tools, test_slony_state.pl (or the DBI version if you prefer). Whatever it warns you about is a likely source of problems. I won't speculate without output from it. -- (reverse (concatenate 'string "ofni.sailifa.ac" "@" "enworbbc")) <http://dba2.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land) _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
