Op 11/02/2011 10:10, J. Echter schreef:
> Am 11.02.2011 09:47, schrieb Valerio Pachera:
>> Hi, I'm using bacula 5.0.2 on debian lenny.
>> I have this directort definition
>>
>> Director {                            # define myself
>>      Name = control-station-director
>>      DIRport = 9101                # where we listen for UA connections
>>      QueryFile = "/etc/bacula/scripts/query.sql"
>>      WorkingDirectory = "/var/lib/bacula"
>>      PidDirectory = "/var/run/bacula"
>>      Maximum Concurrent Jobs = 1
>>      Password = "xxxx"         # Console password
>>      Messages = Daemon
>> }
>>
>> And this FileSet that was already configure by debian:
>>
>> # This is the backup of the catalog
>> FileSet {
>>     Name = "Catalog"
>>     Include {
>>       Options {
>>         signature = MD5
>>         compression = GZIP
>>       }
>>       File = /var/lib/bacula/bacula.sql
>>     }
>> }
>>
>> The file /var/lib/bacula/bacula.sql is empty.
>> Does bacula save by itself the database in the working directory
>> (/var/lib/bacula/) or do I have to dump the database manualy (or by a
>> script)?
>> Because this FileSet was already presente I thought the dump of
>> database was already made by bacula.
>> If it should be like that...than I have something not working with my 
>> director.
>>
>> Last: what is QueryFile in the director definition? Mine is very 
>> old...(julay).
>> Thank you.
>> rceforge.net/lists/listinfo/bacula-users
> Hi,
>
> no there are scripts called make_catalog_backup for example
You need a separate job that makes the export of the database, and uses 
the Catalog fileset, to backup the catalog. An example should be 
provided in the base config file I believe. This is what I'm using (your 
installation might have put the scripts elsewhere):

Job {
   Name = "BackupCatalog"
   JobDefs = "DefaultLinuxJob"
   Client = baculatest-fd
   Level = Full
   FileSet="Catalog"
   Schedule = "RunAfterBackup"
   Max Start Delay = 16h
   Messages = OnError
   RunBeforeJob = "/usr/lib/bacula/make_catalog_backup bacula bacula"
   RunAfterJob  = "/usr/lib/bacula/delete_catalog_backup"
   Max Wait Time = 12h
   Max Run Time = 15h
   Max Start Delay = 15h
   Priority = 12                   # run as last job
}

The beforejob will dump the contents of the bacula catalog using 
mysqldump (will need another script for postgresql I bet), then it'll 
get backupped by the job, and afterwards the dump will be deleted again 
to save space. You can of course opt to use another script to backup the 
catalog, etc.

Kind regards,
Jeremy

 **** DISCLAIMER ****
http://www.schaubroeck.be/maildisclaimer.htm

------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users