immich-app/immich
1
0
Fork 0
mirror of https://github.com/immich-app/immich.git synced 2026-07-25 14:00:45 +03:00
Code Issues 783 Packages Projects Releases 22 Wiki Activity

Migrating postgres database has somehow lost my albums (not photos) #8105

New Issue
Closed
opened 2026-02-05 13:32:06 +03:00 by OVERLORD · 0 comments
OVERLORD commented 2026-02-05 13:32:06 +03:00
Owner
Copy Link

Originally created by @bashers222 on GitHub (Dec 21, 2025).

I have searched the existing issues, both open and closed, to make sure this is not a duplicate report.

  • Yes

The bug

I'm mid migration from immich in Portainer to immich in an LXC using one of the community scripts.
Ive upgraded the inplace immch to 2..4.1 and taken the backup
Whilst its getting closed to success, im not quite there and the process of restoring the database has been the issue is believe.
Originally there were issues restoring the database once id created a user on the new DB.
I noted another comment that said the restore had to be completed on a fresh database so i reinstalled immich and tried again.
Another issue to sort out was issues regarding folder locations changing which were not a problem in Portainer!!
On restoring the database in postgres, there are issues logged pertaining to key constraints but overall it seems to work.
However i now have lost any albums i created i my original install

Should a db restore using the method described here work cleanly, or should i expect errors?
https://docs.immich.app/administration/backup-and-restore
Whatever the state of this latest install, the fact that backups and restores are less than stable is a real concern

The OS that Immich Server is running on

Proxmox debian 13

Version of Immich Server

2.4.1

Version of Immich Mobile App

n/a

Platform with the issue

  • Server
  • Web
  • Mobile

Device make and model

No response

Your docker-compose.yml content

bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/ct/immich.sh)"

Your .env content

TZ=Europe/London
IMMICH_VERSION=release
NODE_ENV=production
DB_HOSTNAME=127.0.0.1
DB_USERNAME=immich
DB_PASSWORD=xxxx
DB_DATABASE_NAME=immich
DB_VECTOR_EXTENSION=vectorchord

REDIS_HOSTNAME=127.0.0.1
IMMICH_MACHINE_LEARNING_URL=http://127.0.0.1:3003
MACHINE_LEARNING_CACHE_FOLDER=/opt/immich/cache
## - For OpenVINO only - uncomment below to increase
## - inference speed while reducing accuracy
## - Default is FP32
# MACHINE_LEARNING_OPENVINO_PRECISION=FP16
IMMICH_MEDIA_LOCATION=/opt/immich/upload
IMMICH_IGNORE_MOUNT_CHECK_ERRORS=true

Reproduction steps

...

Relevant log output

Additional information

No response

Originally created by @bashers222 on GitHub (Dec 21, 2025). ### I have searched the existing issues, both open and closed, to make sure this is not a duplicate report. - [x] Yes ### The bug I'm mid migration from immich in Portainer to immich in an LXC using one of the community scripts. Ive upgraded the inplace immch to 2..4.1 and taken the backup Whilst its getting closed to success, im not quite there and the process of restoring the database has been the issue is believe. Originally there were issues restoring the database once id created a user on the new DB. I noted another comment that said the restore had to be completed on a fresh database so i reinstalled immich and tried again. Another issue to sort out was issues regarding folder locations changing which were not a problem in Portainer!! On restoring the database in postgres, there are issues logged pertaining to key constraints but overall it seems to work. However i now have lost any albums i created i my original install Should a db restore using the method described here work cleanly, or should i expect errors? https://docs.immich.app/administration/backup-and-restore Whatever the state of this latest install, the fact that backups and restores are less than stable is a real concern ### The OS that Immich Server is running on Proxmox debian 13 ### Version of Immich Server 2.4.1 ### Version of Immich Mobile App n/a ### Platform with the issue - [x] Server - [ ] Web - [ ] Mobile ### Device make and model _No response_ ### Your docker-compose.yml content ```YAML bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/ct/immich.sh)" ``` ### Your .env content ```Shell TZ=Europe/London IMMICH_VERSION=release NODE_ENV=production DB_HOSTNAME=127.0.0.1 DB_USERNAME=immich DB_PASSWORD=xxxx DB_DATABASE_NAME=immich DB_VECTOR_EXTENSION=vectorchord REDIS_HOSTNAME=127.0.0.1 IMMICH_MACHINE_LEARNING_URL=http://127.0.0.1:3003 MACHINE_LEARNING_CACHE_FOLDER=/opt/immich/cache ## - For OpenVINO only - uncomment below to increase ## - inference speed while reducing accuracy ## - Default is FP32 # MACHINE_LEARNING_OPENVINO_PRECISION=FP16 IMMICH_MEDIA_LOCATION=/opt/immich/upload IMMICH_IGNORE_MOUNT_CHECK_ERRORS=true ``` ### Reproduction steps 1. 2. 3. ... ### Relevant log output ```shell ``` ### Additional information _No response_
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
accessibility
changelog:enhancement
changelog:security
changelog:skip
changelog:translation
cli
date-time
dependencies
documentation
external-library
format
good first issue
mobile-beta
mobile-beta
mobile-beta
needs-answer
nice to have
pull-request
Mirrored from GitHub Pull Request
 sharing
tech-debt
📱mobile
🖥️web
🗄️server
🧠machine-learning
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: immich-app/immich#8105
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?