46 cards
View
Posted about 1 month ago. Visible to the public.

Barman recovery fails with missing history file

When restoring a barman PITR backup you may encounter this error:

Copy
Copying required WAL segments. EXCEPTION: {'ret': 2, 'err': '/bin/sh: 1: cannot open /var/lib/barman/foopostgres/wals/00000007.history: No such file\n', 'out': ''}

The reason is that the barman backups xlog.db file contains a history file which is no longer present in the wals directory of your backup. The most likely reason is that someone deleted this file in the past. If you do not need this file for restoring your current backup (maybe because it's very old and you try to restore a recent backup) you can rebuild your xlog.db file.

recommendation: never delete the history files in your barman backup directories. Even though you (think) that you will not need them anymore. This will prevent issues like this.

Befe you rebuild you xlog.db file you should create a backup:

Copy
cp /var/lib/barman/foopostgres/wals/xlog.db /var/lib/barman/foopostgres_xlog.db_bck

Afterwards you can rebuild your xlog.db and you recovery should work: \

Copy
barman rebuild-xlogdb foopostgres

What is the xlog.db file?

The file contains metadata about your wal archive on the barman server. It's updated when new WAL data arrives or when barman deletes outdated WAL data. If you delete files manually you will encounter problems when trying to restore a backup.

Owner of this card:

Avatar
Claus-Theodor Riegg
Last edit:
about 1 month ago
by Marius Schuller
This website uses cookies to improve usability and analyze traffic.
Accept or learn more