pg_dump Compression Methods and LevelsAs of Postgres 16, pg_dump can accept a compression method and level. Which method is best? What level should I choose?Nov 13Nov 13
Getting a Redis RDB Dump Out of HerokuHeroku claims you cannot download a Redis RDB dump, but this appears to be a lie. Use redis-cli!Feb 8Feb 8
Converting a Backblaze B2 Bucket to Be S3-CompatibleUse rclone! It will do the server-side copying.May 24, 20231May 24, 20231
Encrypted DNS + NTP = DeadlockI recently found out the hard way that encrypted DNS can deadlock with NTP on embedded devices without a battery-backed clock.Dec 29, 20222Dec 29, 20222
Working with Large Datasets in PostgresLet’s say you want to run a BIG query with gigabytes of results. How do you do it?Dec 27, 2022Dec 27, 2022
Correct Backups Require Filesystem SnapshotsNo matter what backup program you run, using a point-in-time filesystem snapshot is required to achieve correct backups of a running…May 16, 2022May 16, 2022
Costs and Benefits of Local DNSSEC ValidationLet’s take a look at the costs and benefits of enabling DNSSEC validation on the forwarding DNS resolver in your home or business.Dec 20, 2021Dec 20, 2021
Jimmy Wales’ Final EmailJimmy Wales, the founder of Wikipedia, is emailing me? “Signing off”? Is he leaving Wikipedia? Is he dying?! No, just asking for more…Nov 9, 2021Nov 9, 2021
Hit Me with a Wrench All You Want, I Can’t Tell You My PasswordI type my password many times a day to unlock my laptop, but I can’t tell you what it is. I don’t really know it. Let me explain…Sep 23, 20219Sep 23, 20219
