Some bacula/bareos commands

Some bacula/bareos commands

Bacula is a backup software, bareos is a fork of it. Here are some tips and solutions to specific problems.

Adjust an existing volume for pool configuration changes

In bconsole, run the following commands and follow the prompts :

update pool from resource
update all volumes in pool

Using bextract

On the sd you need to have a valid device name with the path to your tape, then run :

bextract -V <volume names separated by |> <device-name>

Integer out of range sql error

If you get an sql error integer out of range for an insert query in the catalog, check the id sequence for the table which had the error. For example with the basefiles table :

select nextval('basefiles_baseid_seq');

You can then fix it with :

alter table BaseFiles alter column baseid set data type bigint;