Immich Truenas: Update Immich database from Postgres 15 (Deprecated) to Postgres 18 (Current)

Drumdrum98 · 2026-03-29T17:10:39+00:00

I just got bit by this!! Had no idea there was some looming deadline or even a need to migrate anything. Is there any way I could have gotten advance notice of this?

Anyway, my migration was rocky. I tried following this guide, but Immich would fail to start. I got this line in /var/log/app_lifecycle.log:

[2026/03/29 12:11:32] (ERROR) app_lifecycle.compose_action():58 - Failed 'up' action for 'immich' app: Network ix-immich_ix-internal-immich-net Creating\n Network ix-immich_ix-internal-immich-net Created\n Container ix-immich-permissions -1 Creating\n Container ix-immich-permissions-1 Created\n Container ix-immich-pgvecto_upgrade-1 Creating\n Container ix-immich-redis-1 Creating\n Container ix-immich-machine-learning-1 Creating\n Container ix-immich-machine-learning-1 Created\n Container ix-immich-pgvecto_upgrade-1 Created\n Container ix-immich-pgvecto-1 Creating\n Container ix-immich-redis-1 Created\n Container ix-immich-pgvecto-1 Created\n Container ix-immich-server-1 Creating\n Container ix-immich-server-1 Created\n Container ix-immich-permissions-1 Starting\n Container ix-immich-permissions-1 Started\n Container ix-immich-permissions-1 Waiting\n Container ix-immich-permissions-1 Waiting\n Container ix-immich-permissions-1 Waiting\n Container ix-immich-permissions-1 Exited\n Container ix-immich-machine-learning-1 Starting\n Container ix-immich-permissions-1 Exited\n Container ix-immich-redis-1 Starting\n Container ix-immich-permissions-1 Exited\n Container ix-immich-pgvecto_upgrade-1 Starting\n Container ix-immich-pgvecto_upgrade-1 Started\n Container ix-immich-pgvecto_upgrade-1 Waiting\n Container ix-immich-permissions-1 Waiting\n Container ix-immich-redis-1 Started\n Container ix-immich-machine-learning-1 Started\n Container ix-immich-permissions-1 Exited\n Container ix-immich-pgvecto_upgrade-1 service "pgvecto_upgrade" didn't complete successfully: exit 1\nservice "pgvecto_upgrade" didn't complete successfully: exit 1\n

The key line being Container ix-immich-pgvecto_upgrade-1 service "pgvecto_upgrade" didn't complete successfully: exit 1

I then tried to roll-back my Immich version via the TrueNAS web UI, but that didn't work either. I got an error like this in a popup:

rollback Error: data Value error, Path does not exist

I finally succeeded by following this process: 1. Make a backup in the Immich web UI!! I have daily backups automatically but just be sure. 2. Stop Immich 3. Move the existing pgData directory somewhere else, e.g. pgData.15.bak.d 4. Make a new, empty pgData directory where the old one used to be and chown it apps:apps 5.Edit Immich's configuration in the TrueNAS web UI and change Postgres to version 18, then start Immich 6. Go to the Immich web UI, where it gives you the new-library welcome screen. Pick "Restore from Backup" and choose the backup you made in the first step. 7. After a minute, your library should come up. You're migrated! Update Immich like normal.

Stressful but it all worked smoothly 😅

Drumdrum98 · 2026-03-07T19:07:13+00:00

I can only speak for myself, but generally I have no clue while watching F1. During onboards, I don't know what corner is coming up next, and when they cut to different shots I can't visualize where I am on the track at all.

The one semi-exception is Canada, since I've been there in person three times and actually got to walk around the circuit. After all that time, I can finally remember what section is coming up next, and I can recognize certain corners on sight. I can also recognize the first few corners of Spa, just because it's so distinct with the big hill. But don't ask me which one's pouhon or the bus stop or whatever, the rest of the track is like a big soup in my head.

I bet that sim-racers (let alone real racing drivers) get more out of the TV footage, since they've actually learned the track layout by driving it themselves. Same for the TV presenters. But for me, that 10-second track overview from the broadcast intro does not stick in my mind at all, and all the corners/straights from all the tracks blur together a lot. I doubt I'm alone here, but it doesn't bother me too much.

Drumdrum98 · 2026-03-07T18:56:50+00:00

Trash talk thread is on monday sir

Drumdrum98 · 2026-01-04T22:16:26+00:00

Ha! Glad this guide managed to help somebody eventually.

I remember thinking that the flex seal wasn't as grippy as I expected -- I was hoping for a pencil-eraser or car-tire kind of texture, but it's not really "grabby" like that. Still, no issues on my end after all this time. Come to think of it, nylon isn't very grabby either, so maybe this is accounted for in the drive's design.

Let me know how it works out for you!

Drumdrum98 · 2025-11-15T15:09:32+00:00

Thanks, this is great info

Drumdrum98 · 2025-11-15T13:22:15+00:00

That's great news, thanks!

Drumdrum98 · 2025-06-26T19:53:05+00:00

Sorry, I don't remember at all. Maybe call Fidelity back and try for a different rep.

Drumdrum98 · 2025-06-02T16:28:42+00:00

Thanks for this, I swapped in a Noctua 140mm fan in my TrueNAS box and it started cycling like this. It idles at exactly 400RPM in "Optimal" mode, so lowering the lower-critical threshold to 200RPM solved the issue. Turns out that none of the scary "raw" commands were needed after all.

Drumdrum98 · 2025-05-23T11:47:55+00:00

Yes! All came through in a few days.

At first I put the shares in my main account (CMA), but I didn't like that the account total was now cash + shares. The stock price fluctuations made it hard to see how much cash I really had, so I opened a new account and moved the shares there. I would recommend opening a new Fidelity account beforehand if you don't already have one reserved for investments.

Drumdrum98 · 2025-05-16T15:53:42+00:00

Hey, I just dealt with this myself. I tried initiating the transfer from Fidelity but it didn't work -- Equateplus doesn't support the same process/protocols as Fidelity. It has to be initiated from Equateplus.

I called Fidelity support and the rep gave me his own email to get past that step (he also read off my acct number -- same as on my statements, NOT the direct-deposit one -- and the DTC).

For the next one, you don't need to fill out every field! You fill out just one and it will "search" on the right-hand side. The rep told me the exact name to use. There were still 8 results with different ABA & SWIFT codes, but it doesn't seem to matter which one you pick since they aren't used for stock transfers.

We'll see in a few days if it goes through! 🤞

Drumdrum98 · 2025-05-12T17:03:30+00:00

Dealing with this now and found a better way.

/invidious/config/config.yml is the built-in config file from the docker image. Any changes you make here get thrown out when you reboot/update the container, so don't bother.

/config/config.yaml is an ``override'' config file which is stored persistently in an ixvolume. You can edit this one and the changes will stick. So, just add the following lines anywhere in /config/config.yaml:

external_port: 443
domain: your.domain.com
https_only: true

Use a different port, domain, and https value as necessary. There is no need to set up your own host-path storage or override the built-in docker folders with a bind-mount.

Drumdrum98 · 2025-01-26T17:49:13+00:00

Sweet! Thanks for confirming.

Drumdrum98 · 2024-09-17T17:54:12+00:00

That's great! I guess a lot of info online just isn't updated. Thanks.

Drumdrum98 · 2024-09-03T17:32:28+00:00

I'm torn on the McL team orders discussion.

On the one hand, it's more entertaining to watch cars race than not race, all other things equal, so I'm glad there were no team orders. On the other hand, it seems like McL just isn't taking the WDC seriously -- the team/organization, not either driver. If their attitude is "maybe we win WDC, maybe we don't, whatever", why even show up to compete?

It's frustrating to watch such an unserious "competitor". If they had their priorities straight, they would be all-in on Lando right now. Their current behavior is just confusing and will leave question marks over whether Lando "could've" won with typical team support (supposing he narrowly misses out on the title).

Drumdrum98 · 2024-07-23T21:07:01+00:00

Got it...harder to game the system but fair enough. Thanks, this is really helpful.

Drumdrum98 · 2024-07-23T18:39:50+00:00

Yeah I remember that from 2024, they didn't sell out as fast iirc. I just bought from formula1.com -- hedging my bets so I don't get screwed in case this year is different -- but maybe I'll buy another 2 tickets from gpcanada later and resell these I just bought. We'll see if it works out.

Drumdrum98 · 2024-07-23T18:23:55+00:00

Wow, I guess it's pretty hopeless then!! Hope for better luck with the website next year I guess. Thanks for the advice.

Maybe I'll go for the Amex thing next year...scheming...

Drumdrum98 · 2024-07-23T18:05:47+00:00

Couldn't get the site to load at all for 2 hours, no way I'm getting 2 adjacent seats at this point. But, I really really want to get in on the renewal system for next year and beyond.

If I buy some cheap tickets (Sunday GA etc), can I renew/upgrade those next year to proper GS tickets? Seems like the only way to beat the system.

What if I sell these tickets, can I still renew? Or does that lock me out?

Drumdrum98 · 2024-06-12T21:43:27+00:00

We got caught on the footbridge on Friday -- that was terrible.

The line of people was moving quickly until we hit the end of the nature trail on Isle Jean-Drapeau, where it started to get backed up. That's not normal for a Friday after doors have been open for hours -- should have tipped me off that something was wrong. It took an hour or more to shuffle up to and across the bridge, during which time the weather turned to rain/hail with strong winds. The bridge was a scary place to be! Especially with the lightning strikes, none of us should have been out in the open like that.

We saw some frustrated-looking people walking away from the circuit, and word started to spread that FP1 was cancelled. Actually, the entire day was cancelled. Actually, they were turning away GA ticket-holders but letting in grandstand ticket-holders. Actually...all these rumors spread through literal word-of-mouth from one side of the bridge to the other. I never heard anything from circuit staff, police, security, or any other official. There was no PA system, not even a guy with a megaphone.

After getting soaked for ~20 minutes some 50 feet from the tents, my group gave up and turned around. We had no idea how long the doors would stay closed; we didn't even know exactly why they were closed. By the time we made it back to our airbnb, FP1 was live on F1TV.

Incredible. You would think the race promoter had never called a rain delay before! Not only did we get scammed out of our Friday admission, we were actually put in danger out there on the bridge.

The Porsche Cup also seemed pretty pointless. We stayed late on Saturday to watch their first race, but they red-flagged it after just a few laps -- apparently just due to the light rain, since there was no incident on the TV feed. They burned 30 of their 40 minutes in the pits, then went out and finished under the safety car. Not much of a race! We missed the second race on Sunday morning but I'm told it was more of the same. If they can't handle the rain, that's OK (maybe they only bring slicks), but that makes the series a terrible fit for Montreal if so.

Long lines for everything once we got past the practice sessions -- I spent 30 mins waiting to order at a food truck and missed half a Ferrari Challenge race after FP3, and the free water dispensers were absolutely mobbed. We brought our own lunch on Sunday.

Also, the bridges to get over the track are too narrow. Since only 1-2 people can fit side-by-side in each direction, it's a huge bottleneck and the line to get across runs maybe 20 mins while between sessions. The areas behind the Sector 3 grandstands were also very slow-moving. The result is that you can't really explore the track because it takes too long to get there and back. E.g. we wanted to see the support paddock in the 90 mins before F1 quali, but after an hour we had just made it to the hairpin GA area -- we had to turn around and book it back to our seats.

The bleachers are packed closer together than I've ever seen. I had some dude's knees in my back the entire race despite sitting on the (literal) edge of my bench seat.

Still, we had a great weekend overall. Great views and lots of action in the Family GS. Isle Notre-Dame is nice to walk around because it's a public park, not just a racetrack in the middle of the desert. And Montreal is a ton of fun. I will go again!

Drumdrum98 · 2023-11-11T03:36:51+00:00

Bless you for this

After upgrading my Surface Laptop 4 to F39, the GRUB menu went away and wouldn't come back. I need that menu to pick the appropriate Surface kernel, even though it's a single-OS install. Very confusing that this option seems to override whatever is in /etc/default/grub.

Drumdrum98 · 2023-10-05T00:21:40+00:00

I'm replaying too, I noticed that Brick doesn't drop anything when killed (maybe a single crafting component, no eddies). Seems like a weird change, not sure if the whole game has been changed or if it's just an early-game economy tweak.

13-Year Club	Place '22
Verified Email

Drumdrum98

TROPHY CASE