I was checking email this (Friday Jul 19, 2024) morning, over coffee, while many IT folks dealt with Cloudstrike fallout, when I noticed this message from the logs: Jul 19 09:12:18 zuul kernel: [zone: pf states] PF states limit reached I’ve seen that message before. It’s not of high concern. That server contains many services […]
What’s this gap in the graphs? Read More »
Nagios was telling me: FILE_AGE WARNING: /usr/home/rsyncer/backups/aws-1/postgresql/freshports.org.dump is 117636 seconds old and 3608113799 bytes That means the FreshPorts backup is more than a day old, and it should have been refreshed by now. OK, let’s go look. I log into the host known as aws-1 and check the files. They look fresh to me: [rsyncer@aws-1
Where’s my backup? Read More »
I have used Tarsnap since at least 2017. The jobs ran nightly. It wasn’t until three years later, that I started cleaning up old backups. Now I’ve found a tool which manages this for me (sysutils/acts) courtesy of a toot by M W Lucas. The selling point of this tool: By default, 31 daily, 12
Using a third party tool to drive tarsnap backups Read More »
I recently moved a Time Capsule instance from a FreeBSD host into a jail. Today, I’m going to create a new Time Capsule which uses Samba instead of AFP. Why? Samba seems to be the preferred solution because AFP has been deprecated. It still works, but let’s go Samba. Not covered in this post, but
Creating a Time Capsule instance using Samba, FreeBSD, and ZFS Read More »
I have Macbooks at home I use them. I use Time Capsule on ZFS on FreeBSD to back them up. In this post: FreeBSD 13.2 OSX Ventura 13.6 I first implemented this directly on the FreeBSD host. Today, I am moving that service into a jail. This post will roughly outline the changes I made
Moving time capsule from host to jail and connecting my MacBook to ZFS on FreeBSD Read More »
I want to copy the latest backups for each Bacula client over to a new host. I already do this, on an automated basis, for recent backups, primarily to have the same backups in two different places. In this case, I want to do this once. This post might also be a good introduction to
Bacula – copying the latest jobs over from one SD to another Read More »
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
Tarsnap – cleaning up old backups Read More »
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
The backups have been wrong for about 97 days Read More »
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 »