Hi to all, 
 
My postgresql log is full with slony logs and it is bad because it is very
hard to check the other logs in the database. How can I separate the slony
log files into a separate file or how can I reduce them?
 
OS: Suse 10, postgre 8.03 slony I. 
 
Most of my logs are something like:
2006-10-21 04:15:33 CEST 16280 - 2133941 LOG:  duration: 0.240 ms
2006-10-21 04:15:33 CEST 16280 - 2133942 LOG:  statement: notify
"_replic_loco_Event"; notify "_replic_loco_Confirm"; insert into
"_replic_loco".sl_event     (ev_origin, ev_seqno, ev_timestamp,
ev_minxid, ev_maxxid, ev_xip, ev_type     ) values ('1', '1532431',
'21/10/2006 04:15:33.039406', '101320395', '101320396', '', 'SYNC'); insert
into "_replic_loco".sl_confirm  (con_origin, con_received, con_seqno,
con_timestamp)    values (1, 2, '1532431', now()); commit transaction;
2006-10-21 04:15:33 CEST 16280 - 2133943 LOG:  duration: 2.466 ms
2006-10-21 04:15:39 CEST 16272 - 652470 LOG:  statement: notify
"_replic_loco_Event"; notify "_replic_loco_Confirm"; insert into
"_replic_loco".sl_event     (ev_origin, ev_seqno, ev_timestamp,
ev_minxid, ev_maxxid, ev_xip, ev_type     ) values ('2', '1459041',
'21/10/2006 04:15:39.107352', '101320427', '101320428', '', 'SYNC'); insert
into "_replic_loco".sl_confirm  (con_origin, con_received, con_seqno,
con_timestamp)    values (2, 1, '1459041', now()); commit transaction;
2006-10-21 04:15:39 CEST 16272 - 652471 LOG:  duration: 1.078 ms
2006-10-21 04:15:43 CEST 16280 - 2133944 LOG:  statement: update
"_replic_loco".sl_setsync set     ssy_seqno = '1532432', ssy_minxid =
'101320449', ssy_maxxid = '101320450',     ssy_xip = '', ssy_action_list =
'' where ssy_setid in (1) and ssy_seqno < '1532432';  
 
....
 
Regards, 
Andy.

Andrei Bintintan
Project Manager,
MPS GmbH
 <mailto:andy at ar-sd.net> andy at ar-sd.net 

"Management means making the things right.
Leadership means making the right things." 

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20061219/0a334c9f/attachment.html