This post has been replaced by a newer post. For reference, the previous post on this server is still available. Today, the host was updated to FreeBSD 14.0, from FreeBSD 13.2. This is my primary developer server in my basement. gpart zpool list zpool status zfs list dmesg sesutil show jls
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 »
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
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 »
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 »
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 »
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 recommended: snapshot your datasets on a regular basis. I like using sanoid for that. That way, if your
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 mounted, but the directories were empty. Stopping, then starting the jail resulted in a proper mount. I wonder
Jails with embedded, but not jailed, ZFS datasets – how to mount/umount Read More »
This post has been replaced by a newer one. For reference, the previous post on this server is still available. Today I noticed this post is out of date. I like to keep this information around for each host, just in case it’s needed during a rescue mission. This is my primary developer server in my basement. gpart zpool list zpool status zfs list dmesg sesutil show jls
This is the Dell R730 host known as R730-03. This post has been replaced by a newer post. It replaces an earlier post. gpart zpool list zpool status File systems dmesg sesutil show jls