I'm running Slony over a Postgresql 8.0.3 server.

My probles is that the log file grows about 3GB/month. How can somehow write the slony logs into another log file, or how can I configurate postgresql that he does not generate all these logs. 

I appreciate any help.

The most of the log messages are:
2005-05-29 21:12:45 CEST 4340 - 5904 LOG:  duration: 0.207 ms
2005-05-29 21:12:45 CEST 4340 - 5905 LOG:  statement: rollback transaction;
2005-05-29 21:12:45 CEST 4340 - 5906 LOG:  duration: 0.089 ms
2005-05-29 21:12:46 CEST 4339 - 5905 LOG:  statement: start transaction;set transaction isolation level serializable;select last_value from "_replic_loco".sl_action_seq;
2005-05-29 21:12:46 CEST 4339 - 5906 LOG:  duration: 0.293 ms
2005-05-29 21:12:46 CEST 4339 - 5907 LOG:  statement: rollback transaction;
2005-05-29 21:12:46 CEST 4339 - 5908 LOG:  duration: 0.097 ms
2005-05-29 21:12:46 CEST 4340 - 5907 LOG:  statement: start transaction;set transaction isolation level serializable;select last_value from "_replic_loco".sl_action_seq; 

And... I usually log the statements... so if this is the solution I will take this out. 

Best regards,
Andy.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050721/8dc5de09/attachment.html