Migrating Immich to a new instance with a different database
I am in the process of changing my self-hosting setup and I'm trying to get Immich back up. I'm using a different compose than the previous one (now I'm using the recommended one) and it uses a different database (old was using
tensorchord/pgvecto-rs:pg14-v0.2.0, now I'm using ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0). I tried starting from scratch and uploading everything from the upload directory with the CLI, but metadata like original file names is lost (presumably stored in the DB). I tried using the previous database, but I'm getting an error about the database role immich not existing and while that could be easily fixed, I'm questioning whether the db would work as is or extra migration steps (if possible at all) would be needed. Does anyone have any guidance on this?