Re: [Bacula-users] Speeding up pruning

2011-04-06 Thread Dermot Beirne
On Apr 5, 2011, at 1:34 PM, Martin Simmons wrote: >> On Tue, 5 Apr 2011 14:35:07 +0100, Dermot Beirne said: >> On Tue, 5 Apr 2011 07:40:44 +0100, Dermot Beirne said: I'm sure that would be fine, but I'm having difficulty automatically determining which volumes are ok to

Re: [Bacula-users] Speeding up pruning

2011-04-05 Thread Dan Langille
On Apr 5, 2011, at 1:34 PM, Martin Simmons wrote: >> On Tue, 5 Apr 2011 14:35:07 +0100, Dermot Beirne said: >> On Tue, 5 Apr 2011 07:40:44 +0100, Dermot Beirne said: I'm sure that would be fine, but I'm having difficulty automatically determining which volumes are ok

Re: [Bacula-users] Speeding up pruning

2011-04-05 Thread Martin Simmons
> On Tue, 5 Apr 2011 14:35:07 +0100, Dermot Beirne said: > > >> On Tue, 5 Apr 2011 07:40:44 +0100, Dermot Beirne said: > >> > >> I'm sure that would be fine, but I'm having difficulty automatically > >> determining which volumes are ok to prune. I need to compare the last > >> written time

[Bacula-users] Speeding up pruning

2011-04-05 Thread Dermot Beirne
>> On Tue, 5 Apr 2011 07:40:44 +0100, Dermot Beirne said: >> >> I'm sure that would be fine, but I'm having difficulty automatically >> determining which volumes are ok to prune. I need to compare the last >> written time to the current time and the volumes retention, and check the >> job type

Re: [Bacula-users] Speeding up pruning

2011-04-05 Thread Martin Simmons
> On Tue, 5 Apr 2011 07:40:44 +0100, Dermot Beirne said: > > I'm sure that would be fine, but I'm having difficulty automatically > determining which volumes are ok to prune. I need to compare the last > written time to the current time and the volumes retention, and check the > job type and s

Re: [Bacula-users] Speeding up pruning

2011-04-04 Thread Dermot Beirne
On 5 Apr 2011 03:43, "Dylan Vanderhoof" wrote: > > Why not run a manual prune command via cron and bconsole for night maint rather than hitting the DB directly? > > I ran into issues where my tapes weren't getting cycled as fast as I'd like, so basically did what you are talking about via bconsole

Re: [Bacula-users] Speeding up pruning

2011-04-04 Thread Dylan Vanderhoof
Why not run a manual prune command via cron and bconsole for night maint rather than hitting the DB directly? I ran into issues where my tapes weren't getting cycled as fast as I'd like, so basically did what you are talking about via bconsole/cron and it seems to have solved the problem. -D

[Bacula-users] Speeding up pruning

2011-04-04 Thread Dermot Beirne
Hi, I'm using bacula 5.0.3 on ubuntu 9.04. I want to know if its possible to find the sql query (or whatever is used) that bacula runs when it needs to prune and recycle a volume. I would like this to run once a night, for each of my disk pools (say via a runscript), to prune them once their rete