Author name: Dan Langille

I've been playing with computers since I read an Elementary Electronics magazine way back in the 1970s. I started contributing to open source projects in 1998. After that, I gradually moved from being a software developer to being a systems administrator.

PostgreSQL: MD5 password support is deprecated – updating the user passwords

Leave a Comment / General, PostgreSQL / By / /

Eight years ago, PostgreSQL introduced scram-sha-256 hashes for passwords. Eleven months ago, MD5 was deprecated. Yesterday, I got caught up with all this. Some of this post will deal with how I fixed it, but mostly it is documenting (for myself) what I did. The fix covers several services and takes place over multiple days. First, some background on why this change has come into focus for me. I have a FreeBSD jail […]

PostgreSQL: MD5 password support is deprecated – updating the user passwords Read More »

r730-01: storage plan

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

Following on from What will I do with those 2 x 1TB drives?, I received a fantastic suggestion from Mike Gerdts. Do more bifurcation. Buy an ASUS HYPER M.2 X16 GEN 4 CARD and put 4x NVMe devices on each one. I can be adding 8 more storage devices to the chassis. I see posts from people using this card in a Dell R730xd – The host in question is a Dell R730.

r730-01: storage plan Read More »

What will I do with those 2 x 1TB drives?

Leave a Comment / Disks, FreeBSD, hardware, Open Source / By /

During zfs: setting compression and adding new vdevs I replace 2x 1TB drives with 2x 4TB drives. This afternoon as I was taking laundry down to the basement, I realized: I have two unused drives in the host. Either I remove them or I repurpose them. I know I have 4x 1TB drives (two SSDs and two NVMe). I could make a 2TB mirror out of them. Where can I use them? r730-03

What will I do with those 2 x 1TB drives? Read More »

zfs: setting compression and adding new vdevs

Leave a Comment / Disks, FreeBSD, hardware, Open Source, ZFS / By /

If you read my recent posts, I’m replacing an existing zpool with new devices. At first, I went to copy the old zpool to a new zpool. I then decided instead of copying, to replace. I’m also going to see about compression. I’m sure it won’t take effect, because replace is a block-by-block copy, or so I think. We’ll confirm. Before Here is the zpool, really, just the top-level filesystem. Notice how compression

zfs: setting compression and adding new vdevs Read More »

Moving a zpool to new devices – after the syncoid copy – oh wait, zfs replace

Leave a Comment / Disks, FreeBSD, hardware, Open Source, ZFS / By /

This morning, as I was typing the subject of this blog post, I realized I don’t have to do this copying. The new devices are staying in this host. It is better for me to add the new devices to the zpool and remove the old devices. That is so much easier. The existing zpool can stay in use and there is no interruption in service. NOTE: after publishing this entry, I realized

Moving a zpool to new devices – after the syncoid copy – oh wait, zfs replace Read More »

Creating the new zpools

Leave a Comment / FreeBSD, Open Source, syncoid, ZFS / By /

I have 4 new storage devices to create 2 new zpools, each a two-vdev mirror. Let’s go. In this post: FreeBSD 14.3 These are the drives I have. As an Amazon Associate I earn from qualifying purchases. The 4TB NVMe cards are Samsung 990 EVO Plus SSD 4TB, PCIe Gen 4×4 | Gen 5×2 M.2 The 4TB SSDs are SAMSUNG 870 EVO 4TB 2.5 Inch SATA III Internal SSD (MZ-77E4T0B/AM) The new data02

Creating the new zpools Read More »

ETCDIR for sysutils/mqttwarn is not as expected

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

I modified my mqttwarn scripts today to ignore some messages. When restarting it, it wouldn’t. No output whatsoever. [20:07 mqtt01 dvl ~] % sudo service mqttwarn restart mqttwarn not running? (check /var/run/mqttwarn/mqttwarn.pid). Starting mqttwarn. [20:07 mqtt01 dvl ~] % sudo ps auwwx | grep warn dvl 4191 0.0 0.0 13836 2408 1 S+J 20:07 0:00.00 grep warn Eventually, I tried running it by hand: [20:08 mqtt01 dvl ~] % sudo /usr/local/bin/mqttwarn Traceback (most

ETCDIR for sysutils/mqttwarn is not as expected Read More »

Compression results

Leave a Comment / Disks, File Systems, FreeBSD, hardware, nvme, Open Source, ZFS, ZFS / By /

Let’s tally up. For reference, this is one of a series of posts regarding compression testing on zpools: Experimenting with compression off Experimenting with compression=lz4 Experimenting with compression=zstd Compression results – you are here Samsung-SSD-870 4TB SSD For the Samsung-SSD-870 4TB SSD no compression we had: 2:34 = 154s 2:32 = 152s 2:30 = 150s 3:52 = 238s 4:46 = 286s 4:16 = 256s 4:15 = 255s 4:15 = 255s 4:49 = 289s

Compression results Read More »

GEOM: nda1: the primary GPT table is corrupt or invalid

Leave a Comment / Disks, FreeBSD, hardware, nvme, Open Source, ZFS / By /

When I destroyed the zpools when I was done with zstd compression testing, these errors appeared in /var/log/messages: You’d be shocked to learn these messages appear when creating a zpool with those devices: [12:21 r730-01 dvl ~/tmp] % sudo zpool create Samsung-SSD-980-PRO-geom-issues mirror /dev/nda1 /dev/nda2 re: Background: these two devices were part of a zpool before I started playing with them. They had partitions on them. Recovery and destroy There may be a

GEOM: nda1: the primary GPT table is corrupt or invalid Read More »

Experimenting with compression=zstd

Leave a Comment / Disks, File Systems, FreeBSD, General, hardware, nvme, Open Source, ZFS, ZFS / By /

Following on from my previous post where I tested lz4, let’s try compression=zstd. Experimenting with compression off Experimenting with compression=lz4 Experimenting with compression=zstd – you are here Compression results First, we delete the old: [21:19 r730-01 dvl ~/tmp] % sudo zpool destroy Samsung-SSD-870-compression-lz4 [21:19 r730-01 dvl ~/tmp] % sudo zpool destroy Samsung-SSD-980-PRO-compression-lz4 [21:19 r730-01 dvl ~/tmp] % sudo zpool destroy Samsung-SSD-990-EVO-compression-lz4 Then create the new: [21:19 r730-01 dvl ~/tmp] % sudo zpool create

Experimenting with compression=zstd Read More »

Scroll to Top