Hello Martin,
Thank you very much for your replay!
But are you sure there are no related data in other table for this data?
Best Regards,
Zhang QZ
-----Original Message-----
From: Martin Simmons [mailto:martin AT lispworks DOT com]
Sent: Tuesday, November 11, 2008 6:57 PM
To: Quanzhong Zhang
Cc: bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] How to clear the restore job history
>>>>> 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
|