Ciao Fabrizio,
I'll answer in English, to be understood by the list.
There are no direct indexes pointing to files from Jobs or Volumes, so deletion of them at each pruning would be very expensive in terms of resources.
Anyway you can delete unuseful items using dbcheck. I have in a daily crontab this command:
/usr/sbin/dbcheck -f -b -c /etc/bacula/bacula-dir.conf > /tmp/dbcheck.log 2>&1
This should free some space for reuse. If you want to shrink the database you must save it with:
/etc/bacula/make_catalog_backup bacula bacula
Then you must drop and rebuld the DB (or drop all its tables) and restore it with:
mysql bacula < /var/bacula/bacula.sql
I hope this will be useful for you or someone else.
--------------------------------------------------------------------------
Ferdinando Pasqualetti
G.T.Dati srl
Tel. 0557310862 - 3356172731 - Fax 055720143
| ".:faber:." <[EMAIL PROTECTED]>
Inviato da: [EMAIL PROTECTED] 22/05/2006 09.39
|
|
Hi to all.
I am a bacula-newbie, and I am trying to use it in a production
environment.
I have notice a weird thing about the File table in bacula database: in
this table, the lines of the files belonging to expired job aren't
deleted so this table will always grow...
Is this correct? And if it is, could you please tell me why is this
done?
I have experienced such things both on PostgreSQL and MySQL, so I think
that this thing is not an error depending on the database engine...
Thanks in advance to anyone who will help me to understand this thing.
--
Fabrizio `faber` Vecchi
-----------------------------------------------
Il cervello e' un organo meraviglioso: comincia
a lavorare fin dal mattino quando ti svegli, e
non smette finche' non vai in ufficio.
-- Paul Frost --
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
