aboutsummaryrefslogtreecommitdiff
path: root/content/blog/miscellaneous/bacula-bareos.md
blob: 19111c311d76a22804c4d7cdf3cd0e81c55a4f24 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
---
title: "Some bacula/bareos commands"
date: 2018-01-10
description: some usefull commands when dealing with bacula or bareos
tags:
  - backups
---

## Introduction

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 :
{{< highlight sh >}}
update pool from resource
update all volumes in pool
{{< /highlight >}}

## Using bextract

On the sd you need to have a valid device name with the path to your tape, then run :
{{< highlight sh >}}
bextract -V <volume names separated by |> <device-name>
<directory-to-store-files>
{{< /highlight >}}

## 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 :
{{< highlight sql >}}
select nextval('basefiles_baseid_seq');
{{< /highlight >}}

You can then fix it with :
{{< highlight sql >}}
alter table BaseFiles alter column baseid set data type bigint;
{{< /highlight >}}