This was said by me on IRC today: You say ‘ignoring a large user base’ as if there is something wrong with that. PostgreSQL has a long history of not catering to the masses. This is what makes it such a great tool. Only well thought out and well conceived features go into PostgreSQL. And someone else said: those 3 statements should be carved to stone :) Done. Later, I added: Features get […]
I’m sure you’ve had one of these moments: ssh to a server start a long running command wanted to disconnect and go home Oh Damn! I should have used screen! I have long wanted such a tool Now there appears to be a solution. reptyr seems to fit the bill. That URL also describes a few other tools: screenify retty I’m hoping someone will port this to FreeBSD soon.
Oh damn! I should have used screen! Read More »
The new year started off poorly for my backups, and it is all my fault. Each of my remote servers is backed up utilizing Bacula’s TLS (Transport Layer Security) features. This requires an X.509 certificate which I obtain via CACert. These certificates have expired: 01-Jan 02:00 bacula-dir JobId 44464: Start Backup JobId 44464, Job=nyi_maildir.2011-01-01_02.00.00_07 01-Jan 02:00 bacula-dir JobId 44464: Using Device “MegaFile” 01-Jan 02:00 bacula-dir JobId 44464: Error: tls.c:92 Error with certificate at
Bacula – certificates expired Read More »
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
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 »
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, 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 »
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
Why not use the tape that’s there? Read More »
Over the past few months, I’ve been getting ready to copy Bacula backups from disk to tape, via a Copy Job. Tonight was my first attempt. I failed. And I think I know why. Concurrency. The output so far: *run job=CopyMegaFileToTape Using Catalog “MyCatalog” Run Copy job JobName: CopyMegaFileToTape Bootstrap: *None* Client: wocker-fd FileSet: wocker files Pool: MegaFile-wocker (From Job resource) Read Storage: MegaFile-wocker (From Pool resource) Write Storage: DigitalTapeLibrary (From Storage from
Running a Bacula Copy Job Read More »