I have about 14,000 data points collected from backups. I started in Oct 2007, but have not done anything with the data. I’d like your help. I have put the data into a PostgreSQL database and dumped it. The dump is here: http://langille.org/tmp/dlt_stats.sql.gz The table looks like: $ psql dan psql (8.4.2) Type “help” for help. dan=# \d dlt_stats Table “public.dlt_stats” Column | Type | Modifiers ————-+—————————–+——————————————————– id | integer | not null […]
I’m thinking about creating a storage box. One with a lot of disk space. It will be used for backups and stuff. I will continue to backup to tape as well. I’m considering this case, which has 8xSATA hot-swap bays: http://www.newegg.com/Product/Product.aspx?Item=N82E16811192058 If I was buying a RAID card, I’d buy this one: http://www.newegg.com/Product/Product.aspx?Item=N82E16816131002&Tpk=areca%201120 But I may go with ZFS instead of hardware RAID.
Both BSDCan and PGCon use Pentabarf for accepting and reviewing proposals for talks. An issue raised in 2009 highlighted the ability to see the speaker name when review the list of submissions. It is a bit of very useful information. This year, I’ve found out that we can see that vital data. Provided the speaker role has been set to confirmed. I think Pentabarf design assumes that you have created a talk, and
Pentabarf – seeing the speakers Read More »
Seen this? /libexec/ld-elf.so.1: Shared object “libcroco-0.6.so.3″ not found, required by ” msgfmt” Rebuild gettext. portupgrade -f gettext And try again Port details, not relevant: # less /var/db/ports/postgresql73/options # This file is auto-generated by ‘make config’. # No user-servicable parts inside! # Options for postgresql-server-7.3.21_1 _OPTIONS_READ=postgresql-server-7.3.21_1 WITH_NLS=true WITHOUT_PAM=true WITHOUT_MIT_KRB5=true WITHOUT_HEIMDAL_KRB5=true WITHOUT_OPTIMIZED_CFLAGS=true WITHOUT_LIBC_R=true WITHOUT_TESTS=true WITHOUT_DEBUG=true The building errors: [root@pg73 /usr/ports/databases/postgresql73-server]# ldd `which msgfmt ` /usr/local/bin/msgfmt: libgettextsrc-0.17.so => /usr/local/lib/libgettextsrc-0.17.so (0x800655000) libgettextlib-0.17.so => /usr/local/lib/libgettextlib-0.17.so (0x80078f000) libcroco-0.6.so.3 =>
“libcroco-0.6.so.3” not found Read More »
NOTE: this problem may not be a problem. After rebooting the system while having the tape library powered up, the problem went away. This may or may not be coincident. Note to self: mtx-changer needs more customization than I thought. Today showed great progress in completing the integration of my tape library into my Bacula system. I have been writing the testing and configuration of supporting tools. I had moved onto a new
mtx-changer script catches me Read More »
Pentabarf is the conference tool used by BSDCan and PGCON. I upgraded it recently and ran into trouble. I think that has been resolved now. Since I last upgraded Pentabarf, it went from using svn to using git. Thus, you need a clean checkout of Pentabarf. I copied away the original source before I did this: git clone git://github.com/nevs/pentabarf.git Then I copied over my existing configuration files: rails/config/*.yml files Then I ran a
Upgrading Pentabarf Read More »
Backups come in three flavors: Full – backup everything Differential – backup everything since the last Full backup Incremental – backup everything since the last backup (Full or Incremental) I took the above from What Is Bacula? Most systems use mtime to determine if a file has changed. Thus, any file that has been modified since the last backup will be picked up in the next incremental or differential backup. Full backups are
I noticed that one of our disk-based Volumes used a label name similar to that of our tape-based Volumes. To avoid confusion, I will rename that Volume. But, renaming a Volume is not simple, nor recommended if the Volume contains data. It is better to migrate the data instead. The Volume in question has MediaId = 42 (seriously!): | 42 | PEQ574L4 | Append | 1 | 4,144,705,431 | 0 | 31,536,000 |
Migrating some Bacula jobs Read More »
I noticed today that the Bacula installation was still using the default File Storage location of /tmp. That is adequate for testing, but we should move it elsewhere. The safest approach to making this change is: stop bacula-sd copy the files to the new location rename the old location amend bacula-sd.conf restart bacula-sd test After you have confirmed everything is OK, you can remove the old location.
Bacula – moving File storage Read More »
I use Bacula. To be clear, I wrote part of Bacula (the PostgreSQL part). Today I need to find out what jobs are on each of three tapes. Why? I just happened to cancel a 1.5TB job a few hours before it was to finish. By this time it had written to three tapes. I am guessing that the last two tapes can be reused. I’m also guessing that the first one cannot
What jobs are on these tapes? Read More »