Issues updating and exporting my database
I have been using immich just about since release, and have had issues updating ever since. I am running a linux server via podman, but whenever I would update versions, the postgress would die. I have had my uploads copy themsleves over and over, so I would like to export what I currently have and start fresh, My server is quite old since I have not updated it in a while, version 1.133.0 while the mobile app is on 1.142.0. The mobile app no longer sees the uploaded files, but they do exist and work on the website version of immich for pc.
TLDR: I want to export all of my current images and completely rebuild immich on my linux server with them
21 Replies
:wave: Hey @橘沙砂saza,
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. :ballot_box_with_check: 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:
https://immich.app/docs/features/command-line-interface
I do not wish to be mean, but I have had a long few days because of this, and never coded a day in my life. This is all beyond me, and a bunch of text poorly explaining commands which I do not understand is not a solution. I was asking for real assistance, but it seems I will most likely just have to migrate to another app instead of immich.
I just fail to see how this solves the problem of my postgress dying every time I update the server, how it helps me export only what is visible in immich (stuff I have not trashed, so I do not have 4 copies of every image), nor how this single link can magically solve my issues. I have read a lot of it. Nowhere does it mention why the postgress would die on update of the server.
I just fail to see how this solves the problem of my postgress dying every time I update the serverIt doesn't, but that didn't seem to be what you were asking for
My apologies, I thought I had stated it in my original message.
"but whenever I would update versions, the postgress would die. I have had my uploads copy themsleves over and over, so I would like to export what I currently have and start fresh"
Is this not the same thing?
Exporting what you have and starting fresh is not the same as figuring out what's wrong with postgres, no
What steps are you taking to update, what sort of storage is the postgres data on, and what exactly does "postgres dying" look like?
It is just corrupted every time it updates itself. I wish I knew better, but it has also happened randomly on restart once.
It is currently in a working condition, but my guess is so out of date that I can not sync with the newest version of mobile
I assume an update will once again cause the postgress to corrupt, so I will be very wary on moving forward
What would I be able to supply to assist with this
What do you mean by “corrupt”? also please know you are running an unsupported deployment (podman)
If you use podman we would expect you have a solid understanding of how to administer and debug your own server
I have a friend who knows a lot about this that would help me set it up and diagnose most problems, but this was even beyond him, so now I have come here
First off, do you have backups?
Because in that case postgres corrupting shouldn't be much more than a simple annoyance
There is a folder labled backups, which I assume is it, but I have never manually made one
Ok then that's priority 0
You really have to have backups, it's not optional
And it's also a prerequisite for messing around to figure out what's wrong
Should I just copy the folder over or is there another way to back it up?
I will give this a try
You should run an actual backup tool and use it to make backups to another system/elsewhere
That's not really specific to Immich, so our docs don't describe it much, but there's plenty to be found on it online (or I'm sure your friend could tell you)
I think I am going to shift my focus to just manually storing my own photos. How am I able to export the entirety of my photos without the really weird file structure in the server folder and keep the when taken information
Thank you
The files you're looking at are the originals with all the metadata fwiw, this link just gives them a nicer folder structure