On Jan 31, 2013, at 7:58 AM, Uwe Schuerkamp wrote:

> Hello list, 
> 
> is it possible to delete several bacula volumes in one go, say like
> so: 
> 
> delete catalog=MyCatalog volume=v01 volume=vol2 ... yes   ? 

Script it.

echo 'catalog=MyCatalog volume=v01 yes' | console

I'm assuming you know how to get a list of those volumes into a script…

> I have several volumes with sizes in the hundreds of gigabytes and I
> assume that deleting them or rather their corresponding file table
> entries in one fell swoop (single delete from sql statement) would be
> faster then deleting them one by one (which takes several hours per
> volume on a 200GB file table with nearly one billion rows).

Why does it take several hours per volumes to delete a volume?  You're just 
acting on the Catalog.

Oh yes, deleting all the file and job references.  Well, perhaps we need to 
look at that took

The database is lacking in referential integrity.  I wish it wasn't.  By 
rights, you should be able to go in
and delete from the media table, and have everything be safe and sound.  i.e. 
no orphans.  But that's not
the case, last time I checked.

So.. yeah, be cautious there.  Sooner or later, you're going to have to let 
those records get deleted.

-- 
Dan Langille - http://langille.org


------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users