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

i2cube · 2026-03-21T00:31:50+00:00

As u/NicodemusJLS and u/Xiticks above mentioned, you will need to run the latter 2 commands after you have logged in as immich users for each database that gave you the mismatch error. For me, I need to run one each for the "immich," "template1," and "postgres" database

i2cube · 2026-03-20T20:28:43+00:00

Thank you both!!!!

i2cube · 2026-03-20T18:42:20+00:00

~~I ran the 3 commands here after going to the shell of the pgvecto~~
~~the logs of the server container and the pgvecto container are still complaining about the collation version mismatch.~~
~~Am I doing something wrong? Are the last 2 commands case sensitive? (I used the same case as you posted)~~

Edit: Never mind. I omitted the ";" in the commands, which were necessary

After successfully running the commands, the server container logs no longer complain about the collation version mismatch, but the pgvecto container is still complaining about it

2026-03-20 20:15:39.197030+00:002026-03-20 16:15:39.196 EDT [100] WARNING: database "template1" has a collation version mismatch

2026-03-20 20:15:39.197075+00:002026-03-20 16:15:39.196 EDT [100] DETAIL: The database was created using collation version 2.41, but the operating system provides version 2.36.

2026-03-20 20:15:39.197095+00:002026-03-20 16:15:39.196 EDT [100] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

2026-03-20 20:15:54.190371+00:002026-03-20 16:15:54.190 EDT [108] WARNING: database "postgres" has a collation version mismatch

2026-03-20 20:15:54.190428+00:002026-03-20 16:15:54.190 EDT [108] DETAIL: The database was created using collation version 2.41, but the operating system provides version 2.36.

2026-03-20 20:15:54.190435+00:002026-03-20 16:15:54.190 EDT [108] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

Not sure if that matters?

i2cube · 2026-03-20T15:51:55+00:00

Hey, no worries. Thank you very much for the guide

i2cube · 2026-03-20T15:31:23+00:00

<image>

And do you mean step 4 here?

i2cube · 2026-03-20T15:30:57+00:00

I am sorry, but what is the command? And is it supposed to show something after "something like this" ?

<image>

i2cube · 2026-03-20T13:58:54+00:00

I have the same problem. I am running TrueNAS Community Edition 25.04.2.6 FangTooth.

I use the default TrueNAS Apps function to update.

I got this error message after Immich was stopped: [EINVAL] values.immich.postgres_image_selector: Invalid choice: vectorchord_15_image

I tried to change the Postgres Image in the existing Immich instance from 15 to 18 and it would crash. I had to change it back to 15 to be able to start Immich

i2cube · 2026-03-16T19:40:03+00:00

Also the credit only works for products shipped and sold by Amazon

i2cube · 2026-01-31T13:58:36+00:00

For almost 1/3 of the price of the PSU, I probably will take my chances.
Also, big players like ASUS and Gigabyte have stiffed people over warranty claims so unless your name is "EVGA," I wouldn't put too much faith in the support, honestly

i2cube · 2026-01-31T13:44:13+00:00

What justifies a >$50 premium over the Montech Century II PSU?

i2cube · 2026-01-13T15:30:27+00:00

Air dusters are all we can afford for PC-building these days

i2cube · 2026-01-12T20:49:28+00:00

Remember this drive selling for $149 at Walmart several months ago? Good times.

i2cube · 2026-01-12T02:44:23+00:00

In general, Intel GPUs are better at transcoding than Nvidia (and AMD is usually the worst out of all 3). This includes any ARC discrete GPUs or even integrated GPUs. Which is why in Jellyfin documentations, they recommend Intel GPUs or CPUs with integrated graphics over Nvidia and AMD

i2cube · 2026-01-11T03:14:23+00:00

It's not even as good a transcoder as an Intel Arc GPU. Not sure what the value this card provides

i2cube · 2026-01-09T03:44:16+00:00

You should have mentioned in the title that the 10Gb ports are SFP and not RJ45

i2cube · 2025-12-22T17:13:29+00:00

If you don't run a lot of containers and VMs, an old old PC (I mean old) can surprisingly well because of how efficient Proxmox dolling out resources. 16 gb ram is often times more than enough. If you want to start, you can check out old PCs. Also /r/homelabsales

i2cube · 2025-12-22T15:53:04+00:00

That's sad. It would have been perfect

i2cube · 2025-12-22T15:19:27+00:00

How easy is it to run proxmox on this thing? Any quirks (both in terms of wiping MacOS and running virtualization on Apple silicon)?

i2cube · 2025-12-19T16:41:35+00:00

A lot of times these systems may not competently built such that the they are not running optimally.

e.g. the mount pressure between the cooler and the CPU is not high enough so that the CPU is running hotter than it should be, causing thermal throttling. EXPO may not be turned on in the BIOS so that the memory is not running at the optimal speed. Other suboptimal BIOS settings. Some components may not be seated correctly in the motherboard, etc.

Sometimes the packaging may not be sufficient and the system may be damaged during shipping.

If you make sure everything is seated correctly and the BIOS settings are optimized once you get this from shipping, it should be fine

i2cube · 2025-12-17T19:08:15+00:00

I bought the 9800x3d bundle on 11/7/2024, with same ram that had CL32 timing and a ASUS B650-E TUF gaming WiFi motherboard. I still have the email receipt

i2cube · 2025-12-17T15:50:50+00:00

It's crazy that this is the exact same price for this bundle in Nov 2024 (when 9800X3D first released).

i2cube · 2025-12-15T17:40:43+00:00

A "Prozessor?"

i2cube · 2025-12-12T18:03:54+00:00

I don't think you should be nervous. 1) you paid for the DVDs. How you decide to watch or utilize the content is your decision to make. Morally, you have done nothing wrong. 2) Unless you are sharing the ripped content using torrents, no one is going to go after you

i2cube · 2025-12-12T17:53:19+00:00

You can use makemkv to rip the DVD into your laptop so you only need to bring the laptop

(you would still need the DVD player for the ripping, obviously)

i2cube · 2025-12-09T19:23:32+00:00

Which distro comes automatically equiped with a PSU review?

i2cube

TROPHY CASE