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 […]
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 »
Some of the newer keyboards do not have a scroll lock key. Try FN-C instead. Does that work for you?
No scroll lock? use FN-C Read More »
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.
AT&T tried to kill BSD Read More »
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 »