Thank you all, I was able to solve the issue as said here https://lemmy.sdf.org/comment/20412456
- 2 Posts
- 5 Comments
I also wanted to mention that normally Immich dumps its own db into a file backup file somewhere. I forgot where. Check the database dump backup cron job in the settings
Hi, thank you. This was the solution. Immich was storing its backup files to DB_UPLOAD (as defined on the .env) file. There will be a backup folder with a bunch of .sql.gz files) Picked one and ran the following command
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 immich_postgres psql --dbname=postgres --username=<DB_USERNAME>As documented on immich’ s website
witx@lemmy.sdf.orgto Selfhosted@lemmy.world•What's up, selfhosters? It's selfhosting Sunday again!English3·14 days agoHow the hell do you get Wger working on http only? I always get the CSRF error even after trying their recommendations
witx@lemmy.sdf.orgto Linux@lemmy.ml•In 2025 Fedora Silverblue has better plug and play than OSX....21·18 days agoRead his comments. He’s likely a 15 year old troll that has learned the word shill just recently
Not sure, I use it containerised though