Bacula-users

Re: [Bacula-users] How to clear the restore job history

2008-11-11 06:02:35
Subject: Re: [Bacula-users] How to clear the restore job history
From: Martin Simmons <martin AT lispworks DOT com>
To: quanzhong.zhang AT xjtlu.edu DOT cn
Date: Tue, 11 Nov 2008 10:57:20 GMT
>>>>> On Tue, 11 Nov 2008 09:28:28 +0800, Quanzhong Zhang said:
> 
> Hello,
> 
> I found there are many restore job history in the table "Job", and can
> not find out the way for clear it.
> Could you kindly give me help?

Bacula never deletes them.

I run the following SQL once a week (on PostgreSQL) to delete those older than
2 months:

delete from job where type in ('V', 'D') and starttime < now()-interval '2 
months';

__Martin

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users