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

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 Job, which is very similar to a Job Copy. With a Job Copy, the original Job remains and

*run A job name must be specified. The defined Job resources are: 1: BackupCatalog 2: RestoreFiles 3: MigrateDiskToTape 4: CopyMegaFileToTape 5: laptop 6: laptop-vpn 7: laptop-wifi-5.3 8: laptop-verify 9: laptop-websites 10: laptop-xp 11: wocker 12: bast basic 13: bast home 14: dbclone basic 15: dbclone home 16: polo basic 17: polo 18: kraken basic 19: kraken 20: nyi maildir 21: nyi maildir tarball 22: nyi basic 23: nyi 24: supernews basic 25: supernews