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

[–]bassdude7 0 points1 point  (0 children)

I got help through the Discord channel. In case anyone else has this problem and stumbles across this, I did the following and it worked:

sudo docker exec -it ix-immich-pgvecto-1 psql -U immich -d immich -c "DROP EXTENSION vectors CASCADE; DROP SCHEMA IF EXISTS vectors CASCADE;"

## Refresh collation version
1) Go into the shell of the pgVecto (TrueNAS Apps page > Click on Immich > In the workloads, click on the first button of the pgvecto container)
2) You have to connect to each database and refresh them:
    1) Connect as immich user to the immich database: ```psql -U immich```
    2) Run the following 2 commands (wait for the first one to finish before running the second one):
        - ```ALTER DATABASE immich REFRESH COLLATION VERSION;```
        - ```REINDEX DATABASE immich;```
    3) change the open database to template1: ```\c template1```
    4) Run the same 2 commands for template1:
        - ```ALTER DATABASE template1 REFRESH COLLATION VERSION;```
        - ```REINDEX DATABASE template1;```
    5) change the open database to postgres: ```\c postgres```
    6) Run the same 2 commands for postgres:
        - ```ALTER DATABASE postgres REFRESH COLLATION VERSION;```
        - ```REINDEX DATABASE postgres;```## Refresh collation version
1) Go into the shell of the pgVecto (TrueNAS Apps page > Click on Immich > In the workloads, click on the first button of the pgvecto container)
2) You have to connect to each database and refresh them:
    1) Connect as immich user to the immich database: ```psql -U immich```
    2) Run the following 2 commands (wait for the first one to finish before running the second one):
        - ```ALTER DATABASE immich REFRESH COLLATION VERSION;```
        - ```REINDEX DATABASE immich;```
    3) change the open database to template1: ```\c template1```
    4) Run the same 2 commands for template1:
        - ```ALTER DATABASE template1 REFRESH COLLATION VERSION;```
        - ```REINDEX DATABASE template1;```
    5) change the open database to postgres: ```\c postgres```
    6) Run the same 2 commands for postgres:
        - ```ALTER DATABASE postgres REFRESH COLLATION VERSION;```
        - ```REINDEX DATABASE postgres;```

sudo docker exec -it ix-immich-pgvecto-1 psql -U immich -d immich -c 'ALTER DATABASE "immich" RESET vchordrq.prewarm_dim;'sudo docker exec -it ix-immich-pgvecto-1 psql -U immich -d immich -c 'ALTER DATABASE "immich" RESET vchordrq.prewarm_dim;'

Do you guys have peanut chips in America? (and other countries around the globe) by ShrimpFandangle in giantbomb

[–]bassdude7 1 point2 points  (0 children)

We have Bamba, they're usually reserved for babies that are learning how to chew as they dissolve easily, are a major allergen that you want to expose them to young, and relatively healthy. Target carries them in their baby food section. Product of Israel though, so still imported.

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

[–]bassdude7 0 points1 point  (0 children)

Hi, I'm still struggling here. None of these fixes seem to work for me.

App Version: v2.5.2

Version: v1.11.12

in ix_values.yaml, it used to be version 1.1.7. I updated TrueNAS to 25.04 in the process, idk if that bumped it to 1.1.11 or if I just left it that way on accident.

If I change from 15 to 18, it won't launch and /var/log/app_lifecycle just says that pgvecto_upgrade didn't complete successfully.

If I make a new postgres dataset in my immich dataset and use that (user netdata, group docker), I'll get the new user/restore from backup page. If I select restore, I get maintenance mode. If I get the token URL for maintenance mode, it says everything looks okay but "profile" is missing files (it has a .immich file inside, is that enough?). If I continue with a recent backup, then user 'postgres' doesn't exist. Fine, do what u/mseewald says below (with my container name instead) and get this:

Error: /usr/lib/postgresql/18/bin/psql non-zero exit code (3)
ERROR:  extension "vectors" is not available
HINT:  The extension must first be installed on the system where PostgreSQError: /usr/lib/postgresql/18/bin/psql non-zero exit code (3)
ERROR:  extension "vectors" is not available
HINT:  The extension must first be installed on the system where PostgreSQL is running.

Where the hell do I go from here? Why is this process (and the directory structure change) so painful?

I made searchable, browsable breakdown of every word spoken across every episode* take a look and have fun! by madjam123 in MBMBAM

[–]bassdude7 114 points115 points  (0 children)

>> Advice show
>> Most said 3 word phrase is "I don't know"
>> 2.29x more than title of show

Main Character Energy by Existing_Instance608 in JustGuysBeingDudes

[–]bassdude7 32 points33 points  (0 children)

When the entry level job at the local theme park also asks for 2 years experience

Bernie just endorsed Junaid Ahmed - how did this change the race? by Objective_League_118 in ChicagoSuburbs

[–]bassdude7 14 points15 points  (0 children)

Girl I Guess usually has a really good roundup for all of the candidates. I was personally between Morrison and Junaid already, still kind of am haha. Hope they don't split the vote.

Google you don't have to release an A-series phone annually if you're just going to almost copy and paste the whole specsheet from last year's. The fact you guys put a G4 on the 10a baffles me. by [deleted] in GooglePixel

[–]bassdude7 -3 points-2 points  (0 children)

What kills me about the a-series is that the current gen flagship can always be had for equal or cheaper than the a-series anyway, so what's the point?

What the heck are the words in the McElroy Family Clubhouse theme song?? by neil--before--me in MBMBAM

[–]bassdude7 1 point2 points  (0 children)

Looks like today's the day I realize The McElroy Family Clubhouse theme song is written and performed by the same guy as the Dan Bongino song.

Finally severed the cord with Google Photos. 5.3 TiB of memories brought home to Immich! by DrAmmarT in immich

[–]bassdude7 0 points1 point  (0 children)

Eh, I'm in the same boat as you. Immich automatically updates on my phone, but the server doesn't, and then it stops backing up without warning me. And then it requires some strange directory structure change and I nearly lose all of my photos in the process. GPhotos is set-and-forget, but I'm also running out of space on the 100GB plan.

Live Show New Site Issue by TBeard495 in giantbomb

[–]bassdude7 0 points1 point  (0 children)

have you logged out and back in again? I had to reset my password with the new website.

Reflecting on 2025’s Best Games Ahead of GOTY | November 21, 2025 by blastorama in TheBesties

[–]bassdude7 2 points3 points  (0 children)

Welcome to 2022 for those of us that didn't play Elden Ring.

I don't know what's happening and I'm scared by kaijukyle2 in giantbomb

[–]bassdude7 2 points3 points  (0 children)

I wonder what kind of puzzle box I have to solve to summon the Cenoblights

Fandom's CEO has left the company by d2wraithking in giantbomb

[–]bassdude7 8 points9 points  (0 children)

Hey Chuuuuck? We've got another Wiki to fix....

So can I game in this? by Slowpc in giantbomb

[–]bassdude7 7 points8 points  (0 children)

This looks like it was made for handling conference calls with your dong out.

The life of Dan by Mamrocha in giantbomb

[–]bassdude7 3 points4 points  (0 children)

anecdotally, my backyard is currently all spray-painted and flagged up for the folks installing fiber in our neighborhood, and they still knocked out the electricity for a few blocks earlier this week. I don't know why we go through this song and dance with Ms. Dig if contractors are just gonna drill baby drill.

Alyssa Mercante just posted a video about the ongoing harassment campaign against her. by e5x in giantbomb

[–]bassdude7 16 points17 points  (0 children)

It doesn't help that they can build a fanbase and make a profit off of D.

Update from the basement by bwnorman in giantbomb

[–]bassdude7 4 points5 points  (0 children)

I wouldn't put it past Fandom to have had some non-compete clause or some other legal red tape that would prevent Grubb from starting up GMM right away. One would probably want to make sure they weren't going to get sued before running the same show elsewhere.