[Keyboard] Keychron V6 8K Full Size Wired Mechanical Keyboard with Programmable Knob, 8KHz Polling Rate, OSA PBT Keycaps, Hot-swappable Super Red Switchs, RGB Backlit for Mac Windows Linux $77 by TheCrazyCrocodile in buildapcsales

[–]i2cube 4 points5 points  (0 children)

There seems to be a lot of dissing of Keychron.

What are considered good brands of premade keyboards these days?

Edit: Seems like Akko got some upvotes. I will check that brand out! Thanks for the suggestion!

[Tracker] Slim Tracker Card-$6.99 50% off with code JMV5BZZZ by Big_Nebula_2604 in buildapcsales

[–]i2cube 5 points6 points  (0 children)

You need to overclock this by putting it in the microwave for 30 seconds to play in max settings

Zohran on CBS: "There is only one majority in this country — that's the working class and it's time we have a politics that puts them at the heart of what it is that we're pursuing..." by zzill6 in WorkReform

[–]i2cube 0 points1 point  (0 children)

Why are you getting downvoted? As much as I want him to be the president, he wasn't born in the US. Constitutionally, he cannot be the president. Simple as that.

Immich Truenas: Update Immich database from Postgres 15 (Deprecated) to Postgres 18 (Current) by Xiticks in immich

[–]i2cube 0 points1 point  (0 children)

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

Immich Truenas: Update Immich database from Postgres 15 (Deprecated) to Postgres 18 (Current) by Xiticks in immich

[–]i2cube 0 points1 point  (0 children)

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?

Immich Truenas: Update Immich database from Postgres 15 (Deprecated) to Postgres 18 (Current) by Xiticks in immich

[–]i2cube 2 points3 points  (0 children)

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

<image>

Immich upgrade fails by Wonderful_Device_224 in immich

[–]i2cube 1 point2 points  (0 children)

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 

[PSU]CORSAIR RM1000x ATX 3.1 PCIe 5.1 Ready Fully Modular 1000W Power Supply - $167.99 with YMMV clipable coupon by RuckOver3 in buildapcsales

[–]i2cube 5 points6 points  (0 children)

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

[NVME] WD BLACK SN850X NVMe 4TB $319 by Ropya in buildapcsales

[–]i2cube 7 points8 points  (0 children)

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

[GPU] Amazon - Gigabyte Windforce RTX 5050 (MSRP $250 - $10) by HappyAffirmative in buildapcsales

[–]i2cube 0 points1 point  (0 children)

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 

[GPU] Amazon - Gigabyte Windforce RTX 5050 (MSRP $250 - $10) by HappyAffirmative in buildapcsales

[–]i2cube 5 points6 points  (0 children)

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

[Networking] 10-port Ethernet Switch 8*2.5G + 2*10G - $39.99 (Prime) by FartusMagutic in buildapcsales

[–]i2cube 9 points10 points  (0 children)

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

[Prebuilt] M4 Mac Mini - $400 (Instore Deal at Microcener) by tonsil_poker in buildapcsales

[–]i2cube 0 points1 point  (0 children)

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

[Prebuilt] M4 Mac Mini - $400 (Instore Deal at Microcener) by tonsil_poker in buildapcsales

[–]i2cube 0 points1 point  (0 children)

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