"Talha Khan" <talha.amjad at gmail.com> 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)