Backups

mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces

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 …

mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces Read More »

The backups have been wrong for about 97 days

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 »

Creating read-only PostgreSQL database users for pg_dump and pg_dumpall

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 »

Moving bacula-sd into a FreeBSD jail

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 …

Moving bacula-sd into a FreeBSD jail Read More »

Bacula – ran out of space, moved some volumes to another zpool

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 »

Bacula – copy to tape by job size

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 …

Bacula – copy to tape by job size Read More »

Scroll to Top