I use Tarsnap for my critical data. Case in point, I use it to backup my Bacula database dump. I use Bacula to backup my hosts. The database in question keeps track of what was backed up, from what host, the file size, checksum, where that backup is now, and many other items. Losing this …
See also Creating read-only PostgreSQL database users for pg_dump and pg_dumpall. I’m linking this because I use both articles on a regular basis. The error After a recent upgrade of MySQL server from 5.7.30 to 5.7.31, my database backups started encountered this error: mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS …
I backup my databases daily. They get dumped to a disk file and copied somewhere else. Then they are backed up into a file system. Once a month they get copied to tape. Yesterday I upgraded a PostgreSQL database server, and it went well. Overnight, a backup failed. This is the story of how that …
See also mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces. I’m linking this because I use both articles on a regular basis. Sometimes you want a user which can only dump the database, but nothing else. Fortunately, I searched, and found a …
Creating read-only PostgreSQL database users for pg_dump and pg_dumpall Read More »
In this post: Bacula 7.4 FreeBSD 11.1 py-iocage 0.9.9.2 I recently wrote about Converting a Dell R710 into a ZFS-based FreeBSD 11.1 tape library bacula-sd and then about getting the drives ready. That system, henceforth referred to as the r710 is now ready for the Bacula setup. Last night I created a jail and installed …
I’m using Bacula 9.0.3 for this post, on FreeBSD 10.3 and 11.1. I did not document this as I went along, however, the details should be enough to get you started. NOTE: when I refer to the bacula-sd configuration, I mean the bacula-sd in question, not necessarily on the same server as bacula-dir. This will …
Bacula – ran out of space, moved some volumes to another zpool Read More »
Backups are pretty amazing. The things you can do with them can be both highly entertaining and surprisingly easy. Today, we will venture into the easy part. Yesterday was the first Sunday of the month, which, according to my Bacula installation’s schedule is the day for full backups. Today, now that that is done, is …
NOTE: I wrote this post nearly two years ago, in May 2015. It has been sitting ignored and unloved in my Drafts. I’ve just published it today. I’m big on backups and I use Bacula. I have about 18 TB on about 350 tapes and about 10 TB of backups on disk. I want more. …
First, all credit goes to Mark Felder’s blog post upon which this is based. You can buy an Apple Time Capsule (I did) to back up your Mac. Now that I have two MacBook’s, I have run out of space, so now I want to backup to ZFS. By backing up to my ZFS filesystem: …
Creating an Apple Time Capsule using FreeBSD & ZFS Read More »
A problem arose today which I have never seen before. I do not know what caused it and I do not know precisely how I fixed it. I am using Baclua 7.0.5 on FreeBSD 9.3 I found this email today: This is Bacula asking for more ‘tape’. I say tape, because that is an easy …