Bacula

Problems with OpenVPN when server is FreeBSD 14.2 and client is 14.1

Leave a Comment / Bacula, FreeBSD, Open Source, OpenVPN / By /

After replacing an existing gateway with new hardware, the OpenVPN connections had issues. The clients would connect, but non-trivial amounts of traffic would cause errors. This post contains a workaround, by upgrading the OS. I would like to know the cause. In this post, these are the version in use: FreeBSD 14.2 (for the OpenVPN server and some of the clients) FreeBSD 14.1 (for some of the clients) OpenVPN 2.6.13 (on the server […]

Problems with OpenVPN when server is FreeBSD 14.2 and client is 14.1 Read More »

Reproducing a batch insert for Bacula on PostgreSQL

Leave a Comment / Bacula, Open Source, PostgreSQL / By /

This work from August 2022 was interesting at the time. My database server gets slow from time to time. It seems to happen repeatedly. I’m not sure why, but inserting large numbers of rows takes a very long time. This is a typical use-case for Bacula when recording what was backed up. I started with this, the duplication of the batch table created when Bacula is storing attribute for later insertion into the

Reproducing a batch insert for Bacula on PostgreSQL Read More »

What’s this gap in the graphs?

Leave a Comment / Backups, Bacula, FreeBSD / By /

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 including PGCon, the former BSDCan website, and my blogs. I didn’t give it much concern, although I should

What’s this gap in the graphs? Read More »

Backing up FreeBSD with Bacula via ZFS snapshot

Leave a Comment / Bacula, Open Source, snapshots, ZFS / By /

Tonight, while watching an episode of The Great British Bake Off, I configured a new Bacula backup jobs to cover some datasets which were not already backed up. I already have a backup jobs to backup all the jails, but only for datasets which sit right under zroot/jails (for example). This new solution takes a list of datasets, snapshots them, backs them up, then destroys those snapshots. Why backup a snapshot? Consistency. During

Backing up FreeBSD with Bacula via ZFS snapshot Read More »

Bacula: Moving from 9.x to 13.x and upgrading the PostgreSQL database

8 Comments / Bacula, FreeBSD, Open Source, PostgreSQL / By /

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 to 13.0.1 (still not the latest release, but that’s because of a minor compile issue, not yet resolved;

Bacula: Moving from 9.x to 13.x and upgrading the PostgreSQL database Read More »

I figured out why pg_dump was failing with PostgreSQL 15-16

Leave a Comment / Bacula, FreeBSD, Open Source, PostgreSQL / By / /

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 for the script was set to / In PostgreSQL < 15, the code used the database to determine

I figured out why pg_dump was failing with PostgreSQL 15-16 Read More »

While restoring my PostgreSQL database to a new FreeBSD server, I discovered the wrong database server in a configuration file

Leave a Comment / Bacula, FreeBSD, Open Source, PostgreSQL / By /

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. I ran a pg_dump on pg02 today. Then a pg_restore on pg03. That took about 6 hours I

While restoring my PostgreSQL database to a new FreeBSD server, I discovered the wrong database server in a configuration file Read More »

pg_dump: error: connection to server failed: fe_sendauth: no password supplied

2 Comments / Bacula, Open Source, PostgreSQL / By / /

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 the wrong database server in a configuration file. The backstory: dbclone dumps the bacula database hosted on pg02.

pg_dump: error: connection to server failed: fe_sendauth: no password supplied Read More »

Bacula: copying jobs from one bacula-sd to another bacula-sd on FreeBSD

Leave a Comment / Bacula, FreeBSD, Open Source / By /

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 jobs over from one SD to another, now that the required space is installed and configured. In this

Bacula: copying jobs from one bacula-sd to another bacula-sd on FreeBSD Read More »

Scroll to Top