I

Immich•2mo ago•

80 replies

-=|DrDoom|=-

Restore from Backup doesn't work

Solved🗄️Server❓Question

Hi,
was running a TrueNAS Server with Immich worked for almost 1 year very good. TrueNAS ZFS Pool went down and is now dead.
I try to recover with my backup TerraMaster F4-424 TOS6 Docker install, but it did'nt worked as i hoped. Immich is running on the TerraMaster no problem but when trying to restore the Database with

gunzip < "/path/to/backup/dump.sql.gz" | docker exec -i immich_postgres psql --username=postgres # Restore Backup
docker compose up -d # Start remainder of Immich apps

or with

gunzip < "/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 --username=postgres

SET
SET
SET
DROP DATABASE
DROP ROLE
NOTICE: role "immich" does not exist, skipping
CREATE ROLE
ALTER ROLE
SET
SET
SET
SET
SET
set_config
------------

(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

i really need some help!

THANK YOU