Last night I was working on a PostgreSQL function which would take a bunch of rows from one table and update rows in another table. This is part of the FreshPorts packages project. When I ran it from the command line, it worked as expected. When I ran it from within a script, the DELETE […]
Just let me check the docs…. Read More »
If you have a blog, or anything online, I’m sure you have received an email saying: Hey, great article, would you mind linking to my website please? A few days later: hey! did you get my email? Then later still: I know you’re busy…. The one I received today was at first annoying but then
link request spammers – sometimes they help Read More »
This is just a placeholder for me to find this later. I was cleaning up some old snapshots. I’m not sure I should have removed those snapshots and I’m saving this here for next time I use bectl. [dan@slocum:~] $ grep -v autosnap ~/tmp/snapshots/snapshots zroot/bootenv/default@2020-01-11-18:16:51 zroot/bootenv/default/tmp@2020-01-11-18:16:51 zroot/bootenv/default/usr@2020-01-11-18:16:51 zroot/bootenv/default/usr/local@2020-01-11-18:16:51 zroot/bootenv/default/usr/obj@2020-01-11-18:16:51 zroot/bootenv/default/usr/src@2020-01-11-18:16:51 zroot/bootenv/default/var@2020-01-11-18:16:51 zroot/bootenv/default/var/audit@2020-01-11-18:16:51 zroot/bootenv/default/var/empty@2020-01-11-18:16:51 zroot/bootenv/default/var/log@2020-01-11-18:16:51 zroot/bootenv/default/var/tmp@2020-01-11-18:16:51
This sounds slightly political, and it is. Intentionally so. 1. the capacity to recover quickly from difficulties; toughness. “the often remarkable resilience of so many British institutions” 2. the ability of a substance or object to spring back into shape; elasticity. “nylon is excellent in wearability and resilience” Christophe Pettus recently said: Right up until
Right up until you need it, resilience looks like waste Read More »
Sometimes I’ll be thinking about the hardware I have which is not in use. I’ll know it exists, but not the details. I’ll be in the wrong part of the house to have a quick look, or I might be nowhere near the house when the topic comes up. This post fixes that. These are
2FA has its critics: It’s so unreliable! Phones are so easily hijacked It’s not a lot of added security etc Some of these make assumptions not necessarily in evidence. In this post: FreeBSD 12.1 pam_google_authenticator-1.08 Most of the 2FA I use is time-based one-off passwords (TOTP), as opposed to text messages. These are often 6-digit
I backup my databases daily. They get dumped to a disk file and copied somewhere else. Then they are backed up into a file system. Once a month they get copied to tape. Yesterday I upgraded a PostgreSQL database server, and it went well. Overnight, a backup failed. This is the story of how that
The backups have been wrong for about 97 days Read More »
Be warned, this failed. I’m stalled and I have not completed this. I’m going to do jails within a jail. I already do that with poudriere in a jail but here I want to test an older version of iocage before upgrading my current jail hosts to a newer version. In this post: FreeBSD 12.1
Creating a ZFS dataset for testing iocage within a jail Read More »
You’ve seen it. A package gets installed. Some shell scripts are included. They get modified. It happens. But how do you know what has changed? I know there is a tool in pkg for this. I know there is a periodic script which uses it. Let’s go looking. In this post: FreeBSD 12.1 periodic $
What files installed by this package have been modified post-install? Read More »
FreshPorts runs on a FreeBSD server which hosts multiple jails. Two of these jails run PostgreSQL server. When upgrading from one version of PostgreSQL to another, we run pg_dump in the new jail, and load the backup into that database server. I’m writing this blog post to keep track of this procedure so I do
Migrating FreshPorts from one db server to another Read More »