Open Source

Copying to tape, missed something….

I recently wrote about copying jobs with a very good backup tool. My goal was to keep copies of the backups on both disk and tape. Since then, I started playing around with a little webpage to keep tabs on what’s in my tape libary. Today I noticed a little problem. I have backups from 75 days ago that are waiting to be copied to tape.

I’ll just let you think about why this happened. Yesterday, this queue held jobs that were about 16 hours old. How did this old job get into the queue?

Copying to tape, missed something…. Read More »

Bacula – certificates expired

The new year started off poorly for my backups, and it is all my fault. Each of my remote servers is backed up utilizing Bacula’s TLS (Transport Layer Security) features. This requires an X.509 certificate which I obtain via CACert. These certificates have expired: 01-Jan 02:00 bacula-dir JobId 44464: Start Backup JobId 44464, Job=nyi_maildir.2011-01-01_02.00.00_07 01-Jan

Bacula – certificates expired Read More »

zfs destroy

Here I go, removing an old ZFS dataset that is no longer required. But first, some stats (which have been edited to remove non-zfs output): [dan@kraken:~] $ df -h Filesystem Size Used Avail Capacity Mounted on storage 1.4T 15G 1.4T 1% /storage storage/bacula.DO.NOT.USE 5.8T 4.4T 1.4T 76% /storage/bacula.DO.NOT.USE storage/compressed 1.4T 49K 1.4T 0% /storage/compressed storage/compressed/bacula

zfs destroy Read More »

How much are those volumes in the library? (redone)

I have an improvement on the original query. This one outputs ‘nil’ if the volume is empty. bacula=# SELECT mediaid, volumename, volstatus, slot, inchanger, pool.name, CASE WHEN volbytes < = 64512 THEN 'nil' else pg_size_pretty(volbytes) END FROM media, pool WHERE media.poolid = pool.poolid AND volumename LIKE 'ETU0%' AND inchanger != 0 ORDER BY slot; mediaid

How much are those volumes in the library? (redone) Read More »

How much are those volumes in the library?

I pretty much ignore my tape library. It asks for tapes when it runs out. However, I think I should be looking ahead and anticipating requests. Thus, I came up with this SQL query: [dan@ngaio:~] $ psql bacula psql (8.4.5) Type “help” for help. bacula=# SELECT mediaid, volumename, volstatus, slot, inchanger, pool.name, volbytes FROM media,

How much are those volumes in the library? Read More »

Bacula Copy Job

With Bacula, a great piece of backup software [disclosure: I wrote the PostgreSQL module for Bacula], you can copy a Job after it has run. This is often used to backup first to disk, and then Copy that Job to tape. That is exactly what I’ve been doing recently. NOTE: You can also migrate a

Bacula Copy Job Read More »

Scroll to Top