On Monday 18 December 2006 23:21, Forum wrote:
> 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?

The easiest way would be to do an "alter user <my_slony_user> set 
log_statement to 'none'"  on all the nodes.


>
> 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."