👾 hackr
👾 hackr
PostsComments
IImmich
Created by 👾 hackr on 5/11/2025 in #help-desk-support
How am I supposed to restore a database when the service I deploy doesn't have immich-postgres?
Okay so here's my write-up and complete process for restoring a backup onto a TrueNAS Scale System via immich installed via the app market: A few Notes: - for my specific case, I was on postgres 16 when I had the immich service running on my unraid server - at the time of writing, the immich image available via the TrueNAS Apps Store included postgres 15 Steps: 1. install the immich app. Make sure to assign actual accessible stoage points for all the config items (except machine-learning, that one can stay as is). 2. login to the terminal (I preferred to login as truenas_admin via ssh and then sudo -s to start a session as root so I don't need to keep typing sudo and my password each time 3. using docker, stop all the services for the immich service (should be the following ones: ix-immich-server-1,ix-immich-pgvecto-1,ix-immich-machine-learning-1, and ix-immich-redis-1) [NOTE: Do not try stopping it from the UI as it also removes the containers. you need to keep them created but just showing up as "crashed" in the ui] 4. navigate to your selected database location (for me this was /mnt/SSDs/immich/database) and delete everything inside using rm -rf ./* 5. run docker start ix-immich-pgvector-1 and wait until the database is fully up and running (check status via docker ps) 6. run the following but replace items in the angled brackets with your own parameters for your system 
gunzip --stdout "</path/to/backup/dump.sql.gz>" \
| sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" \
| docker exec -i ix-immich-pgvecto-1 psql -U immich --dbname=postgres --username=<immich>  # Restore Backup
gunzip --stdout "</path/to/backup/dump.sql.gz>" \
| sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" \
| docker exec -i ix-immich-pgvecto-1 psql -U immich --dbname=postgres --username=<immich>  # Restore Backup
7. start the rest of your docker services pertaining to immich 8. reintroduce your missing thumbnails, files, etc by copying them over smb, nfs, a literal flash drive, whatever. 9. rebuild your missing thumbnails etc that are missing and do any remaining cleanup tasks via the admin maintenance dashboard as needed
16 replies
IImmich
Created by 👾 hackr on 5/11/2025 in #help-desk-support
How am I supposed to restore a database when the service I deploy doesn't have immich-postgres?
(I figured it out, will post updates soon in case anyone needs the instructions)
16 replies
IImmich
Created by 👾 hackr on 5/11/2025 in #help-desk-support
How am I supposed to restore a database when the service I deploy doesn't have immich-postgres?
(also to note, I was using version 16 of the postgres db and immich on unraid but truenas expects v 15. I'm going to try restoring down to a previous version anyways and hope that works? - if not I'm going to create a small temp vm and store my files there for the time being maybe)
16 replies
IImmich
Created by 👾 hackr on 5/11/2025 in #help-desk-support
How am I supposed to restore a database when the service I deploy doesn't have immich-postgres?
No description
16 replies
IImmich
Created by 👾 hackr on 5/11/2025 in #help-desk-support
How am I supposed to restore a database when the service I deploy doesn't have immich-postgres?
got it!
16 replies
IImmich
Created by 👾 hackr on 5/11/2025 in #help-desk-support
How am I supposed to restore a database when the service I deploy doesn't have immich-postgres?
okay - I assumed as much, I did try to restore it via that container name but it gave me another error I lost track of - I'll send it over once I find it again.
16 replies
IImmich
Created by 👾 hackr on 5/11/2025 in #help-desk-support
How am I supposed to restore a database when the service I deploy doesn't have immich-postgres?
No description
16 replies
IImmich
Created by 👾 hackr on 5/11/2025 in #help-desk-support
How am I supposed to restore a database when the service I deploy doesn't have immich-postgres?
No description
16 replies
IImmich
Created by 👾 hackr on 5/11/2025 in #help-desk-support
How am I supposed to restore a database when the service I deploy doesn't have immich-postgres?
I don't exactly have docker compose files or a .env - so not 100% sure what to put here but I have attached all my containers, detailed the software/os. Hardware is just your typical x86 machine on the AM4 platform w 64GB DDR4 memory etc
16 replies