Restored backup with errors, bad or ok?
Used https://immich.app/docs/administration/backup-and-restore/ to make and restore backup. Just to verify all working.
Repo:
All db files deleted before postgres start. Immich server stopped.
Latest release.
Backup:
Restore result:
Relevant log from postgres container:
Repo:
ghcr.io/immich-app/postgres:16-vectorchord0.3.0ghcr.io/immich-app/postgres:16-vectorchord0.3.0All db files deleted before postgres start. Immich server stopped.
Latest release.
Backup:
docker exec -t immich_postgres pg_dumpall --clean --if-exists --username=postgres | gzip > dump.sql.gzdocker exec -t immich_postgres pg_dumpall --clean --if-exists --username=postgres | gzip > dump.sql.gzRestore result:
snip
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
ERROR: failed to parse options: TOML parse error at line 1, column 1
|
1 |
| ^
CREATE INDEX
ERROR: failed to parse options: TOML parse error at line 1, column 1
|
1 |
| ^
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
snipsnip
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
ERROR: failed to parse options: TOML parse error at line 1, column 1
|
1 |
| ^
CREATE INDEX
ERROR: failed to parse options: TOML parse error at line 1, column 1
|
1 |
| ^
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
snipRelevant log from postgres container:
2025-05-25 13:15:08.384 CEST [80] ERROR: failed to parse options: TOML parse error at line 1, column 1
|
1 |
| ^
2025-05-25 13:15:08.384 CEST [80] STATEMENT: CREATE INDEX clip_index ON public.smart_search USING vchordrq (embedding public.vector_cosine_ops) WITH (options='
residual_quantization = false
[build.internal]
lists = [1]
spherical_centroids = true
build_threads = 4
sampling_factor = 1024
');
2025-05-25 13:15:08.405 CEST [80] ERROR: failed to parse options: TOML parse error at line 1, column 1
|
1 |
| ^
2025-05-25 13:15:08.405 CEST [80] STATEMENT: CREATE INDEX face_index ON public.face_search USING vchordrq (embedding public.vector_cosine_ops) WITH (options='
residual_quantization = false
[build.internal]
lists = [1]
spherical_centroids = true
build_threads = 4
sampling_factor = 1024
');2025-05-25 13:15:08.384 CEST [80] ERROR: failed to parse options: TOML parse error at line 1, column 1
|
1 |
| ^
2025-05-25 13:15:08.384 CEST [80] STATEMENT: CREATE INDEX clip_index ON public.smart_search USING vchordrq (embedding public.vector_cosine_ops) WITH (options='
residual_quantization = false
[build.internal]
lists = [1]
spherical_centroids = true
build_threads = 4
sampling_factor = 1024
');
2025-05-25 13:15:08.405 CEST [80] ERROR: failed to parse options: TOML parse error at line 1, column 1
|
1 |
| ^
2025-05-25 13:15:08.405 CEST [80] STATEMENT: CREATE INDEX face_index ON public.face_search USING vchordrq (embedding public.vector_cosine_ops) WITH (options='
residual_quantization = false
[build.internal]
lists = [1]
spherical_centroids = true
build_threads = 4
sampling_factor = 1024
');message.txt7.37KB
