DanielPT
IImmich
•Created by DanielPT on 5/22/2025 in #help-desk-support
Upgrading postgresql
I think you can do the upgrade just fine. Buttt make a backup 😉
34 replies
IImmich
•Created by DanielPT on 5/22/2025 in #help-desk-support
Upgrading postgresql
Meaby 🙂 But make a backup first 🙂
34 replies
IImmich
•Created by DanielPT on 5/22/2025 in #help-desk-support
Upgrading postgresql
I just used the CA store and pointed at ghcr.io/immich-app/postgres:16-vectorchord0.3.0-pgvectors0.3.0
34 replies
IImmich
•Created by DanielPT on 5/22/2025 in #help-desk-support
Upgrading postgresql
Yeap. I just install a new dcoker 16. I used pg_dumpall to backup my DBs and then used chatgpt to import them 🙂 I seems working 🙂 I just dont ahve the cast icon 😦
34 replies
IImmich
•Created by DanielPT on 5/22/2025 in #help-desk-support
Upgrading postgresql
Okay what a ride and thanks to Chatgpt. I have now installed a new PostgreSQL16 witth ghcr.io/immich-app/postgres:16-vectorchord0.3.0-pgvectors0.3.0.
i can see this in the logs:
[Nest] 215 - 05/23/2025, 4:03:24 PM LOG [Api:DatabaseRepository] Migration "1744991379464-AddNotificationsTable" succeeded
[Nest] 215 - 05/23/2025, 4:03:24 PM LOG [Api:DatabaseRepository] Migration "1745244781846-AddUserAvatarColorColumn" succeeded
[Nest] 215 - 05/23/2025, 4:03:24 PM LOG [Api:DatabaseRepository] Migration "1745902563899-AddAssetVisibilityColumn" succeeded
[Nest] 215 - 05/23/2025, 4:03:24 PM LOG [Api:DatabaseRepository] Migration "1746636476623-DropExtraIndexes" succeeded
[Nest] 215 - 05/23/2025, 4:03:24 PM LOG [Api:DatabaseRepository] Migration "1746768490606-AddUserPincode" succeeded
[Nest] 215 - 05/23/2025, 4:03:24 PM LOG [Api:DatabaseRepository] Migration "1746844028242-AddLockedVisibilityEnum" succeeded
[Nest] 215 - 05/23/2025, 4:03:24 PM LOG [Api:DatabaseRepository] Migration "1746987967923-AddPinExpiresAtColumn" succeeded
[Nest] 215 - 05/23/2025, 4:03:24 PM LOG [Api:DatabaseRepository] Migration "1747329504572-AddNewSessionColumns" succeeded
[Nest] 215 - 05/23/2025, 4:03:24 PM LOG [Api:DatabaseRepository] Migration "1747338664832-SessionRename" succeeded
[Nest] 215 - 05/23/2025, 4:03:24 PM LOG [Api:DatabaseRepository] Migration "1747664684909-AddAlbumAuditTables" succeeded
But how can i be sure it is using vector ?
34 replies
IImmich
•Created by DanielPT on 5/22/2025 in #help-desk-support
Upgrading postgresql
Hehe no this is a bit tricky 😦
34 replies
IImmich
•Created by DanielPT on 5/22/2025 in #help-desk-support
Upgrading postgresql
But do i need a VectorChord docker installed? 😄
34 replies
IImmich
•Created by DanielPT on 5/22/2025 in #help-desk-support
Upgrading postgresql
Hehe that is fair enough. Im not a DB expert sorry 🙂
34 replies
IImmich
•Created by DanielPT on 5/22/2025 in #help-desk-support
Upgrading postgresql
This is tricky
"The easiest option is to have both extensions installed during the migration:"
What does that mean? i have a Postgresql docker installed not a VectorChord ?
34 replies
IImmich
•Created by DanielPT on 5/22/2025 in #help-desk-support
Upgrading postgresql
Ouh? But my Immich user dosent have superuser on my outher databases? 🙂
34 replies