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 »

Jails with embedded, but not jailed, ZFS datasets – how to mount/umount – corrected

3 Comments / FreeBSD, Jails, ZFS / By /

This is a rewrite of Jails with embedded, but not jailed, ZFS datasets – how to mount/umount. First, this is not about jailed ZFS datasets. I use them for FreshPorts, but that’s not I’m going to talk about here. In this post: FreeBSD 13.2 This is my example: [22:25 r730-03 dvl ~] % zfs list | grep bacula-sd-04 data01/bacula-volumes 12.1T 4.18T 96K /jails/bacula-sd-04/usr/local/bacula/volumes data01/bacula-volumes/DiffFile 109G 915G 109G /jails/bacula-sd-04/usr/local/bacula/volumes/DiffFile data01/bacula-volumes/FullFile 4.00T 2.00T 3.89T /jails/bacula-sd-04/usr/local/bacula/volumes/FullFile

Jails with embedded, but not jailed, ZFS datasets – how to mount/umount – corrected Read More »

Moving 4x storage devices into a new home

Leave a Comment / Disks, FreeBSD, hardware, nvme, R730, ZFS / By /

Yesterday I did some scavenging of some servers which I’m going to dispose of. I managed to put together 4 x 1TB storage devices: 2 x NVMe sticks and 2 x SSDs. I also pulled a riser card from an R730 and relocated it to another host. The NVMe sticks are mounted on these PCIe cards, which I do not regret buying. They came with full height and low-profile brackets. More to the

Moving 4x storage devices into a new home Read More »

Preparing a server for sale – Supermicro 846 – 10 x 5TB HDD

Leave a Comment / Disks, File Systems, hardware, R730, ZFS / By /

FYI: This server has since gone to a new home. After powering off the server about 8 months ago, I took the first steps to selling it. I opened it up and took out 2x NVMe sticks (1TB each, ZFS mirrored, giving a 930G zpool) INTEL fiber NIC (Intel X540-AT2) I’ll be keeping those items. I also took an inventory of the drives still in the system: 10 x 5TB drives – all

Preparing a server for sale – Supermicro 846 – 10 x 5TB HDD Read More »

pg_dump: error: query failed: ERROR: permission denied for sequence cache_clearing_files_id_seq

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

Skip to the end of this post for the lesson part of this blog post. This email arrived in my inbox yesterday at about 10:00 PM: This is the backup script for my database dumps on my server at home. I immediately recognized it as the follow-on from a table I had just added. It was late, I was headed to bed. I forgot about it. Until this morning. This morning This morning,

pg_dump: error: query failed: ERROR: permission denied for sequence cache_clearing_files_id_seq Read More »

Got a pkg vuln you can’t get rid of?

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

I’ve been working on this for a while. [23:18 r730-01 dvl ~] % pkg audit curl-8.4.0 is vulnerable: curl — SOCKS5 heap buffer overflow CVE: CVE-2023-38545 WWW: https://vuxml.FreeBSD.org/freebsd/d6c19e8c-6806-11ee-9464-b42e991fc52e.html 1 problem(s) in 1 installed package(s) found. [23:18 r730-01 dvl ~] % The original vuxml entry got it wrong. This problem was fixed in 8.4.0 A subsequent commit fixed that. So why am I still having this problem 48 hours later? mtime. This Mastodon thread

Got a pkg vuln you can’t get rid of? Read More »

acm.esh key ’/var/db/acme/certs.int.unixathome.org.key’ is unreadable

Leave a Comment / Let's Encrypt, Security / By /

Today, while mucking about with a new cronjob and log file for acme.sh, I stumbled across these error messages: Why was I stumbling around? This email arrived after the daily cert renewal: Three skips. Three error messages. Let’s look at that file: [18:37 certs dan ~] % sudo ls -l /var/db/acme/certs.int.unixathome.org.key -rw-r—– 1 root acme 116 Oct 6 20:21 /var/db/acme/certs.int.unixathome.org.key That should be readable. I checked some ZFS snapshots from earlier this week.

acm.esh key ’/var/db/acme/certs.int.unixathome.org.key’ is unreadable Read More »

Scroll to Top