Restore question
So I'm using portainer on server 1 (synology NAS) for my immich stack.
I've setup a second server (synology NAS) on which I'm planning to test my dump files for server 1 for recovery
On that server 2 I use container manager (docker) project.
I have mimicked everything, filled in the .env file as per server 1 and also the docker compose.
Can I just create the project ( without starting containers) then start the sql db and inside the db run:
gunzip < "/path/to/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=<DB_USERNAME>
?
After this I manually start the remainder containers
I've setup a second server (synology NAS) on which I'm planning to test my dump files for server 1 for recovery
On that server 2 I use container manager (docker) project.
I have mimicked everything, filled in the .env file as per server 1 and also the docker compose.
Can I just create the project ( without starting containers) then start the sql db and inside the db run:
gunzip < "/path/to/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=<DB_USERNAME>
?
After this I manually start the remainder containers
