Restoring automatic db backup on windows
Currently trying to restore from a backup db i have.
Following the windows system guide
## Uncomment the next line and replace DB_DATA_LOCATION with your Postgres path to permanently reset the Postgres database
# Remove-Item -Recurse -Force DB_DATA_LOCATION # CAUTION! Deletes all Immich data to start from scratch
i need to replace the database location with pgdata as per windows instructions but it says that cannot find path because it does not exist.
is pg data not what im supposed to delete?25 Replies
:wave: Hey @OOF,
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. :ballot_box_with_check: 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.
Successfully submitted, a tag has been added to inform contributors. :white_check_mark:did the backup with the username as postgres and nothing
trying to restore from a .gz so used gunzip
mounted as required for windows
If you
docker compose down -v and have been using a pgdata volume then it will be deletedPerfect
gunzip < "/dump.sql" \
Im assuming that is supposed to be the same as the mount?
The part after the :
| psql --dbname=postgres --username=<DB_USERNAME> # Restore Backup
And i left the defaults in the .env so
Is username postgres?
yes
The dump.sql is indeed simply whatever you mounted it to
in your screenshot, /dump.sql
You also shouldn’t be using gunzip if it’s not a gz
I’m not sure where that snippet came from
Do i need to change the :/dump.sql to :/dump.sql.gz
?
Because the backup is a .gz
Not sure where im going wrong. Not getting any errors but when i launch immich after restoring, it acts as a clean install, not recognising my library
All happening in powershell as required
Of course you need to reference the actual file, yes
i feel like this should work
but when i launch immich it doesn't
am i missing something simple?
am i misunderstanding the mount?
It seems to think your file is a directory somehow
At least that's how I understand the output of gzip
Are you sure you re created the containers after adding the mount?
Are you sure the source file exists?
certain
100%
Im fairly sure this isn’t correct. Docker will make a directory if the file mount source doesn’t exist
We discourage windows use for reasons like this, file paths can be very tricky
Can you show the path of the dump file on the cmd line?
ok so i just changed the path
to like this
and it pulled from the db
and remembers my credentials and i think has my images
but has error loading image on all thumbnails and images
"D:\New-Immich-Files\library\backups\immich-db-backup-1740195057897.sql.gz"
i just copied the path from file explorer
That just means your UPLOAD_LOCATION isn't set to the old location yet
i've not changed anything in the .env though?
will change to the same file path style as the yaml
ok wow
yea that fixed it
only had it the /mnt/ way becuase the windows path did't work for me before
'D:\New-Immich-Files\library' worked
for my record
thanks guys!
should i unmount the db backup now?
from volumes in the compose file?
or just leave it there
also, where is --dbname=postgres defined?
i assume --username=<DB_USERNAME> is defined in the .env as DB_USERNAME
You can but it doesn't hurt 😛
In the env file
ty
This thread has been closed. To re-open, use the button below.