Bacula

pg_dump: aborting because of server version mismatch

Here’s something to be aware of. Update your PostgreSQL client on your Bacula client if it is used for backing up the Catalog. Ngaios just told me: FILE_AGE WARNING: /usr/backups/bacula/MyCatalog.dump is 45125 seconds old and 0 bytes I looked at the backup job from earlier today: 28-Dec 08:15 bacula-dir JobId 195194: shell command: run BeforeJob

pg_dump: aborting because of server version mismatch Read More »

Bacula restore using a regex

Short version: I used this regex when restoring to a jail on the slocum server: !/\.zfs/snapshot/snapshot-for-backup/!/! Background Today I did this when setting up an ssh-key on a new host: ssh-add -L > ~/.ssh/authorized_keys Oh. That should have been >>. Restoring During the Bacula restore, I need to change this path: /usr/jails/mydev/.zfs/snapshot/snapshot-for-backup/usr/home/dan/.ssh/ to /usr/jails/mydev/usr/home/dan/.ssh/ That

Bacula restore using a regex Read More »

Older versions of Bacula – copy/migrate has limit of 99 jobs

Last night I started to catch up on copying jobs from disk to tape. There were about 420 incremental jobs waiting. I started my CopyToTape-Inc job, and it queued up 417 jobs: The next morning, all jobs had completed, but there were still jobs left to be copied over (as determined by my magical Bacula

Older versions of Bacula – copy/migrate has limit of 99 jobs Read More »

Bacula btape test of Compaq Storage Works MSL5026 Library

This output is a Bacula btape test of the library mentioned in this post. $ sudo btape -c /usr/local/etc/bacula/bacula-sd.conf /dev/nsa0 Tape block granularity is 1024 bytes. btape: butil.c:290 Using device: “/dev/nsa0” for writing. btape: btape.c:477 open device “DTL03” (/dev/nsa0): OK *test === Write, rewind, and re-read test === I’m going to write 10000 records and

Bacula btape test of Compaq Storage Works MSL5026 Library Read More »

Bacula: indexing on media.lastwritten

I wrote this nearly a year ago, but did not publish it then. Tonight I found this query running, so I tried an explain analyse on it: That’s 10 seconds. Add an index: bacula=# create index media_lastwritten_idx on media(lastwritten); CREATE INDEX Run the query again: Forgive my math, but that’s over 10,000 times faster now.

Bacula: indexing on media.lastwritten Read More »

Script for listing the latest ZFS snapshot – starting place for Bacula backups

This post has it all: backups deduplication snapshots ZFS Bacula ezjail Backups are essential for proper sanity, or at least, a reasonable facsimile. I strongly believe that doing backups right is the only way to backup. Go big or go home. I’ve been converting all my servers to ZFS. I like ZFS for many reasons,

Script for listing the latest ZFS snapshot – starting place for Bacula backups Read More »

Scroll to Top