WalkerOfTheDay
WalkerOfTheDay
PostsComments
IImmich
Created by WalkerOfTheDay on 5/1/2025 in #help-desk-support
Moving from docker for Windows to Linux (Mint?).
Thanla again. What about my other questions regarding the NTFS usb drive? Do you or anyone else know?
14 replies
IImmich
Created by WalkerOfTheDay on 5/1/2025 in #help-desk-support
Moving from docker for Windows to Linux (Mint?).
So I can just change the gunzip line to what you said ?
14 replies
IImmich
Created by WalkerOfTheDay on 5/1/2025 in #help-desk-support
Moving from docker for Windows to Linux (Mint?).
docker compose down -v  # CAUTION! Deletes all Immich data to start from scratch
## Uncomment the next line and replace DB_DATA_LOCATION with your Postgres path to permanently reset the Postgres database
# rm -rf DB_DATA_LOCATION # CAUTION! Deletes all Immich data to start from scratch
docker compose pull             # Update to latest version of Immich (if desired)
docker compose create           # Create Docker containers for Immich apps without running them
docker start immich_postgres    # Start Postgres server
sleep 10                        # Wait for Postgres server to start up
# Check the database user if you deviated from the default
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>  # Restore Backup
docker compose up -d            # Start remainder of Immich apps
docker compose down -v  # CAUTION! Deletes all Immich data to start from scratch
## Uncomment the next line and replace DB_DATA_LOCATION with your Postgres path to permanently reset the Postgres database
# rm -rf DB_DATA_LOCATION # CAUTION! Deletes all Immich data to start from scratch
docker compose pull             # Update to latest version of Immich (if desired)
docker compose create           # Create Docker containers for Immich apps without running them
docker start immich_postgres    # Start Postgres server
sleep 10                        # Wait for Postgres server to start up
# Check the database user if you deviated from the default
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>  # Restore Backup
docker compose up -d            # Start remainder of Immich apps
14 replies
IImmich
Created by WalkerOfTheDay on 5/1/2025 in #help-desk-support
Moving from docker for Windows to Linux (Mint?).
Thanks for your reply @Mraedis. Basically my question is, how do I restore the backup I made on windows (dump.sql) on onto a new Linux installation ? The restore instructions for Linux talk about .gz files but I do not have it, because I made the backup on Windows.
14 replies