Automatic DB Backups help
So I'm reading DB backups are just as important as the actual media files. I have automatic DB backups turned on in the settings but I am not seeing them in the UPLOAD_LOCATION/backups folder.
Also the postgresql log doesn't show any activity since 1/3/25 and the entries don't really show anything that indicates any backup was done. The Immich server log does actually show a DB backup succesful message though but I don't know where it's being saved at:
[Nest] 8 - 01/22/2025, 1:46:40 AM LOG [Microservices:BackupService] Database Backup Success
I noticed there was an update that had optional steps to add a DB_DATA_LOCATION to the .env and compose file but I didn't do that as it says it was optional.
My media is backed up via Proxmox backup server but I want to make sure the DB is also being backed up.
Thank you!
7 Replies
:wave: Hey @metalgod3082,
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_01GY0DAKGXDEHE263BCAYEGFJAChecklist
I have...
1. :blue_square: verified I'm on the latest release(note that mobile app releases may take some time).
2. :blue_square: read applicable release notes.
3. :blue_square: reviewed the FAQs for known issues.
4. :blue_square: reviewed Github for known issues.
5. :blue_square: tried accessing Immich via local ip (without a custom reverse proxy).
6. :blue_square: 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.GitHub
immich-app immich · Discussions
Explore the GitHub Discussions forum for immich-app immich. Discuss code, ask questions & collaborate with the developer community.
FAQ | Immich
User
GitHub
Issues · immich-app/immich
High performance self-hosted photo and video management solution. - Issues · immich-app/immich
Because of the way you've set up your custom locations, you're not mounting the automatic db dumps folder
I read through that but i'm still not quite understanding what I need to do to fix this
Ok maybe I see it now. Do I just need to add the BACKUP_LOCATION=/custom/path/immich/backups to env and ${BACKUP_LOCATION}:/usr/src/app/upload/backups to compose?
Sure but you also do not have any mount point for /usr/src/app/upload
See how we don’t mount upload/library/ and upload/upload/ folders separately , we mount the root then selected sub folders
ok yeah I see that. Is there a way to fix those mount points iwthout breaking everything?
I think the reason I did it like this initially was to have my media files like images and videos on my mass HDD zfs volume and everthing else on the fast ssd