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 »
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
Jails with embedded, but not jailed, ZFS datasets – how to mount/umount – corrected Read More »
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
Moving 4x storage devices into a new home Read More »
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
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
Got a pkg vuln you can’t get rid of? 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 »
This approach did not work, because I used the wrong set of filesystems. See below for Error. This post has been replaced by Jails with embedded, but not jailed, ZFS datasets – how to mount/umount – corrected. NOTE: on yesterday’s (2023-10-04) reboot, the file systems did not properly mount. zfs get mounted said they were
Jails with embedded, but not jailed, ZFS datasets – how to mount/umount 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’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 »