December 2010

zfs destroy

Leave a Comment / ZFS / By /

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 4.4T 3.0T 1.4T 68% /storage/compressed/bacula storage/compressed/home 1.4T 2.7G 1.4T 0% /storage/compressed/home storage/pgsql 1.4T 5.5G 1.4T 0% /storage/pgsql And […]

zfs destroy Read More »

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

Leave a Comment / Bacula / By /

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 | volumename | volstatus | slot | inchanger | name | pg_size_pretty ---------+------------+-----------+------+-----------+---------------+---------------- 1328 | ETU021 | Append

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

How much are those volumes in the library?

Leave a Comment / Bacula, Open Source, PostgreSQL / By /

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, 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? Read More »

Scroll to Top