2014

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 »

su: _secure_path: /nonexistent/.login_conf is not owned by uid 65534

This morning, on a FreeBSD 9.2-RELEASE #0 r255898 system, I saw this in /var/log/messages: There was nothing around that entry to clue me in. I suspected a cronjob, based upon the time of day. I searched with Google and found only questions. This next command confirms my cronjob suspicion: OK, it’s got to be a

su: _secure_path: /nonexistent/.login_conf is not owned by uid 65534 Read More »

Scroll to Top