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

[bashers222]

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

[molivier-io]

I had the same experience last week as well. Due to fan issue, I had to move immich on another computer and I lost my albums and faces. The worse is I have these albums in my mobile app, but I'm unable to sync them back to the server.

[molivier-io]

I was using option --schema=public with pg_dump, and the importation process skipped some insertions with PG17.
I had to re-dump the main database without this option to recover the database (and albums) in the right way.

Then I wiped the mobile app storage in order to force the synchronization of new images with the server again.

[dlopez76]

Hi, I'm facing the same problem migrating from Docker to proxmox LXC. It seems that the album tables (album, album_asset, album_asset_audit and album_user) are empty.
I'm get the data of these tables from the older system and insert into the new system via SQL., and now I can view all tha albums with their assets.

[mmomjian]

We do not support the community script, sorry to hear about this issue but we recommend reaching out to them.