|
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.
|
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
