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 […]

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
[…]

Some of the newer keyboards do not have a scroll lock key. Try FN-C instead. Does that work for you?

I cannot claim this. Will Backman said:

Thing I think about while driving: BSD. AT&T tries to kill BSD. Steve Jobs uses BSD to save Apple. Apple makes the iPhone. iPhone is tied to AT&T. iPhone activations save AT&T from the recession. BSD saved AT&T.

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 […]