Restore DB-Backup under TrueNAS or dockge?
My immich-app is not starting any more. After giving the app a new dataset for the Postgres Data Storage, I can start up the app again, but it’s like a fresh installation.
I have a dump.sql.gz from the database from yesterday.
How can this be done for immich under TrueNAS or dockge?
5 Replies
:wave: Hey @Nordlicht-13,
Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:.
References
- Container Logs:
docker compose logs docs
- Container Status: docker ps -a docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
- Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA
Checklist
I have...
1. :ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time).
2. :ballot_box_with_check: read applicable release notes.
3. :ballot_box_with_check: reviewed the FAQs for known issues.
4. :ballot_box_with_check: reviewed Github for known issues.
5. :ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy).
6. :blue_square: uploaded the relevant information (see below).
7. :blue_square: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable
(an item can be marked as "complete" by reacting with the appropriate number)
Information
In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:
- Your docker-compose.yml and .env files.
- Logs from all the containers and their status (see above).
- All the troubleshooting steps you've tried so far.
- Any recent changes you've made to Immich or your system.
- Details about your system (both software/OS and hardware).
- Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h).
- The version of the Immich server, mobile app, and other relevant pieces.
- Any other information that you think might be relevant.
Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)
If this ticket can be closed you can use the /close command, and re-open it later if needed.Log from pgvecto-container
[2024/12/31 00:02:56] (ERROR) app_lifecycle.compose_action():56 - Failed 'up' action for 'immich' app: Network ix-immich_default Creating
Network ix-immich_default Created
Container ix-immich-permissions-1 Creating
time="2024-12-31T00:02:50+01:00" level=warning msg="config
uid, gid and mode are not supported, they will be ignored"
time="2024-12-31T00:02:50+01:00" level=warning msg="config uid, gid and mode are not supported, they will be ignored"
Container ix-immich-permissions-1 Created
Container ix-immich-machine-learning-1 Creating
Container ix-immich-pgvecto-1 Creating
Container ix-immich-redis-1 Creating
Container ix-immich-redis-1 Created
Container ix-immich-pgvecto-1 Created
Container ix-immich-machine-learning-1 Created
Container ix-immich-server-1 Creating
Container ix-immich-server-1 Created
Container ix-immich-permissions-1 Starting
Container ix-immich-permissions-1 Started
Container ix-immich-permissions-1 Waiting
Container ix-immich-permissions-1 Waiting
Container ix-immich-permissions-1 Waiting
Container ix-immich-permissions-1 Exited
Container ix-immich-redis-1 Starting
Container ix-immich-permissions-1 Exited
Container ix-immich-pgvecto-1 Starting
Container ix-immich-permissions-1 Exited
Container ix-immich-machine-learning-1 Starting
Container ix-immich-machine-learning-1 Started
Container ix-immich-redis-1 Started
Container ix-immich-pgvecto-1 Started
Container ix-immich-pgvecto-1 Waiting
Container ix-immich-redis-1 Waiting
Container ix-immich-machine-learning-1 Waiting
Container ix-immich-permissions-1 Waiting
Container ix-immich-permissions-1 Exited
Container ix-immich-pgvecto-1 Error
Container ix-immich-machine-learning-1 Healthy
Container ix-immich-redis-1 Healthy
dependency failed to start: container ix-immich-pgvecto-1 is unhealthy
That was the log from TrueNAS /var/log/app_lifecycle.log
I found the docker dockge stacks and tried to restore the sql-dump.
But I get the following error:
root@truenas[...Apps_Data/dockge/dockge_stacks/immich]# gunzip < "/mnt/diskpool-1/office/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 --username=postgres
docker compose up -d
SET
SET
SET
DROP DATABASE
NOTICE: role "immich" does not exist, skipping
DROP ROLE
CREATE ROLE
ALTER ROLE
SET
SET
SET
SET
SET
set_config
--------------------
public, pg_catalog
(1 row)
SET
SET
SET
SET
UPDATE 1
DROP DATABASE
ERROR: option "locale_provider" not recognized
LINE 1: ...late1 WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PRO...
^
ERROR: database "template1" does not exist
\connect: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: database "template1" does not exist
[+] Running 4/4
✔ Container immich_postgres Running 0.0s
✔ Container immich_redis Started 0.4s
✔ Container immich_machine_learning Started 0.4s
✔ Container immich_server StartedEverything else from restore has no problems.
Got it running again under dockge. Had to use tensorchord/pgvecto-rs:pg16-v0.2.0 for the DB. Should it be changed to prodrigestivill/postgres-backup-local:14? If so, can you tell me how?