I have been using Bacula since 2004. It is my backup solution of choice, not only because it has a PostgreSQL backend, but it is flexible, robust, and reliable. I, on the other hand, have long ignored recent releases. I’m using Bacula 9.6.7 (released on 2021-01-26), roughly 3 years ago. Today, I started the upgrade …
Bacula: Moving from 9.x to 13.x and upgrading the PostgreSQL database Read More »
In recent blog post, I outlined a problem I hit with pg_dump. Specifically, pg_dump was picking up and using ~/.pgpass with pg_dump from PostgreSQL 12-14, but with PostgreSQL 15-16, it was failing. In this blog post: FreeBSD 13.2 PostgreSQL server 12 / 16 PostgreSQL client 12-16 Bacula 9.6.7 Today we figured out why: $HOME. $HOME …
I figured out why pg_dump was failing with PostgreSQL 15-16 Read More »
Lately, I’ve been preparing to move from PostgreSQL 12 to PostgreSQL 16 – my main developement database server at home needs to get updated. The goal: migrate each database from the old host (running PostgreSQL 12) to the new host (running PostgreSQL 16) using pg_dump and pg_restore. Today, I decided to migrate the Bacula database. …
FYI, this problem has been solved and described in I figured out why pg_dump was failing with PostgreSQL 15-16. This morning I encountered this error message: In this post: FreeBSD 13.2 PostgreSQL 12.16 (server – pg02) PostgreSQL 16.1 (client – dbclone) See also While restoring my PostgreSQL database to a new FreeBSD server, I discovered …
pg_dump: error: connection to server failed: fe_sendauth: no password supplied Read More »
I’m moving some backups from one bacula-sd to another bacula-sd. If you don’t know what that means, this is not the post for you. You need more Bacula knowledge. I’m retiring a host and moving some of the backups on that host to another host. This post follows on from Bacula – copying the latest …
Bacula: copying jobs from one bacula-sd to another bacula-sd on FreeBSD Read More »
This post covers my debugging of a self-signed certificate on one of my Bacula instances. The error message is: I’ve encountered that unsupported certificate purpose message before: OpenVPN: unsupported certificate purpose SSL client vs server certificates and bacula-fd I always thought it was a server versus client issue. Now I’m not so sure. There was …
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’ve used Bacula since at least January 2004 (so nearly 20 years). I liked it so much I dropped my deployment-in-motion of another tool (if you search lightly, you can find out which one). I liked it so much, I wrote a PostgreSQL backend for it. This post is not for Bacula novices. This post …
Bacula – calculating Maximum Volume Bytes and Maximum Volumes based on historical data Read More »
Sometimes I mess up. Then I have to clean up and redo. These help me do that. This deletes FullAutoNoNextPool-12954 to FullAutoNoNextPool-12958. This creates FullAutoNoNextPool-12954 to FullAutoNoNextPool-12958.
This is not a significant post. It is for the record. I received 20 new LTO4 tapes recently. I attached the external labels to them after using https://kelvin.nu/barcode *label barcodes pool=Scratch storage=bacula-sd-02 drive=0 slot=1-7,11-15,17-23,39,47 Connecting to Storage daemon bacula-sd-02 at bacula-sd-02.int.unixathome.org:9103 … 3306 Issuing autochanger “slots” command. Device “bacula-sd-02” has 47 slots. Connecting to Storage …