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:[EMAIL PROTECTED]> [EMAIL PROTECTED]
"Management means making the things right.
Leadership means making the right things."
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
