Dan Langille
banner
langille.org
Dan Langille
@langille.org
That guy. BSDCan. PGCon. The FreeBSD Diary. FreshPorts.

https://langille.org/
This just in...

While `zpool replace` does not allow you to use a smaller drives, `zpool add` does.

re: mastodon.social/@bob_zim@inf...

re: bsd.network/web/@dvl/115...
November 11, 2025 at 3:39 PM
Should I move from BIOS booting to UEFI on my Dell R730?

I've never used UEFI on my hosts, and I'll be moving my zroot zpool to new devices soon.

#FreeBSD
November 11, 2025 at 1:08 PM
How would you move the zroot zpool from a #ZFS mirror of 2x 450GB to 2x 128GB devices?

Ideally, I'd use `zpool replace` but that can't go to smaller devices.

Sounds like I must:

* run gpart on the new drives
* boot live thumbdrive
* zfs send receive
* stamp bootcode

#FreeBSD
November 10, 2025 at 8:10 PM
This is a game changer.

I am moving from 2.5" SATA SSDs for the OS to SATADOM modules.

www.ebay.com/itm/16787998...

2x 128GB SSD devices, directly attached to the Dell R730 MB.
Pardon Our Interruption...
www.ebay.com
November 10, 2025 at 7:21 PM
I have monitoring checks to ensure all zpools are fine (e.g. zpool status).

I don't have one which verifies a given list of zpools all exist.
November 10, 2025 at 12:43 AM
Let’s see how this works.
November 9, 2025 at 6:55 PM
Parts ordered at MicroCenter - just waiting for "ready for pickup" signal and I'm off.

That means I'll be installing the new hardware today - instead of my usual wait-for-delivery process.

Blog post and photos later, perhaps today.
November 9, 2025 at 5:29 PM
It's upgrade from PostgreSQL 18-beta to 18.0

gist.github.com/dlangille/81...

With that started, let's head off to the coffee shop.
It's database upgrade time
It's database upgrade time. GitHub Gist: instantly share code, notes, and snippets.
gist.github.com
November 9, 2025 at 2:23 PM
Sudden realization: A Dell R730 can fill up all the PCIe slots and contain 16x NVMe devices.

Say with 4TB devices = 64 TB.

Wow, that's ridiculous.

dan.langille.org/2025/11/08/r...
r730-01: storage plan – Dan Langille's Other Diary
dan.langille.org
November 8, 2025 at 9:54 PM
BSDCan — BSDCan
BSDCan is a technical BSD conference held in Ottawa, Ontario, Canada.
www.bsdcan.org
November 8, 2025 at 1:06 PM
I'm sure I've done this before....

I have four devices: 2x 2TB and 2x 1TB

I could concatenate a 1TB and a 2TB together, then mirror over both.

It can survive one device dying. However, it seems like an ugly risky hack.

#FreeBSD #ZFS

1/2
November 3, 2025 at 7:09 PM
I've just added new item to list of future tasks:

0000335: MD5 password support is deprecated and will be removed in a future release of #PostgreSQL

From www.postgresql.org/docs/current...

To upgrade an existing installation from md5 to scram-sha-256, ....

1/2
20.5. Password Authentication
20.5. Password Authentication # There are several password-based authentication methods. These methods operate similarly but differ in how the users' passwords …
www.postgresql.org
November 1, 2025 at 1:29 PM
Tomorrow brings the realization that globals.sql contains tablespace references:

[11:43 dbclone dvl ~/bin] % grep 'CREATE TABLESPACE' ~rsyncer/backups/pg01/database-backup/postgresql/globals.sql
CREATE TABLESPACE snaproll OWNER postgres LOCATION '/var/db/postgres.freshports.dvl';

#postgresql

1/2
The #FreeBSD jail known as dbclone receives database backups, then does a restore. A persistent error I'm getting during a #PostgreSQL pg_restore is:

ERROR: directory "/var/db/postgres.freshports.dvl" does not exist

1/5
October 31, 2025 at 11:52 AM
Reposted by Dan Langille
If any of my past work on #OpenBSD, or my highlight posts here (or Twitter/Mastodon) has been helpful to you, a small recurring monthly donation would be extremely appreciated. Reposts welcome. 🍕🐡

brynet.ca/wallofpizza....

bc1qzkchnc25yeqt9p24edsu5ln0mvh8hqdzdznlk2

#HelpSky #MutualAid
Donate to Bryan Steele
Help support Bryan Steele by donating or sharing with your friends.
www.paypal.com
October 1, 2025 at 12:37 PM
The #FreeBSD jail known as dbclone receives database backups, then does a restore. A persistent error I'm getting during a #PostgreSQL pg_restore is:

ERROR: directory "/var/db/postgres.freshports.dvl" does not exist

1/5
October 30, 2025 at 11:23 AM
Now that I've decided to do `zfs replace` instead of `zfs send | zfs recv`, I've hit a conundrum.

If I want to move from lz4 to zstd, the `send | recv` is the way to go. Best I can do is change the zpool compression manually. That will only affect new writes.

#FreeBSD #zfs

1/2
October 18, 2025 at 12:39 PM
Dan does compression - I have three zpools - let's try using it without compression, with lz4, and with zstd.

dan.langille.org/2025/10/06/c...
Compression results – Dan Langille's Other Diary
dan.langille.org
October 6, 2025 at 11:36 AM
Reposted by Dan Langille
Have you tried github.com/ish-app/ish? Uses normal Alpine, but probably isn’t as well integrated into iOS.
GitHub - ish-app/ish: Linux shell for iOS
Linux shell for iOS. Contribute to ish-app/ish development by creating an account on GitHub.
github.com
September 3, 2025 at 3:49 PM
I think I'm going to give holzschu.github.io/a-Shell_iOS/ a go on my old iPad.

"A text-based user interface for a screen-based platform"

I wonder if it has OpenSSH ssh?
a-Shell
A text-based user interface for a screen-based platform
holzschu.github.io
September 1, 2025 at 5:38 PM
I started running short on disk space for the non-production @FreshPorts hosts. This time, I've decided to ask for donations.

dan.langille.org/2025/08/29/r...

Which means my Patreon account has been activated.
Running short on space on the FreshPorts development zpool – Dan Langille's Other Diary
dan.langille.org
August 29, 2025 at 9:47 PM
I need help figuring out why this script succeeds on the command line and does not do the right thing when launched from other scripts.

news.freshports.org/2025/08/26/w...

#perl #PostgreSQL #FreeBSD
Why does this PostgreSQL \copy fail when launched by the daemon? – FreshPorts News
news.freshports.org
August 26, 2025 at 7:36 PM
I checked #Nagios and noticed that some hosts had a vuln Apache.

Grabbed from SamDrucker:

samdrucker=# select host from hostswithpackageshowversion('apache24');

Some hosts didn't enable Apache - they had it installed, but didn't run it.

Fallout from github.com/freebsd/pkg/...
pkg-upgrade installs the package if it is not installed · Issue #2481 · freebsd/pkg
pkg upgrade foo will install foo if it not installed. This breaks POLA given man pkg-upgrade says: Moreover, pkg upgrade will not install new packages, except as required to fulfill dependencies of...
github.com
August 16, 2025 at 9:48 PM
Found this 4GB IDE drive in a desktop being recycled from a relative’s home. PSU fires up but screen remains blank. I may have to resort to destruction to dispose of this. Usually I just dd over the drive. That’s enough for this use case.
August 16, 2025 at 7:56 PM
Hoping to get this trim primed & installed today. Perhaps painted tomorrow.
August 16, 2025 at 1:31 PM