messed up my postgres database, need help restoring.
Hi! Over the past week, my TrueNAS scale applications died, and I had no immich, I fixed the issues with TrueNAS but immich still didn't work. I chalked up the problem to some sort of version incompatibiility between the app and the server(which was still at v1.128) and tried upgrading. I ran into some issues with some sort of config change, and I just ended up backing the data up(since it was in an ixVolume), nuking the old app and installing the new app.
I mistakenly selected postgres 18 when re-installing the app, and that nuked my data directory. I managed to restore a backup the upgrade process made, although I'm not 100% sure if I did it right.
However, now I run into the postgres container complaining about
I found this: https://docs.immich.app/administration/postgres-standalone/#migrating-from-pgvectors, but I don't think I can follow that for docker container? I'm sorry I'm not the most experienced with docker.
How can I correctly restore the database so the latest immich version will launch?
I can provide any more information that is needed, and any help would be greatly appreciated.
I mistakenly selected postgres 18 when re-installing the app, and that nuked my data directory. I managed to restore a backup the upgrade process made, although I'm not 100% sure if I did it right.
However, now I run into the postgres container complaining about
PostgresError: could not access file "$libdir/vectors": No such file or directory, stack: PostgresError: could not access file "$libdir/vectors": No such file or directory. I found this: https://docs.immich.app/administration/postgres-standalone/#migrating-from-pgvectors, but I don't think I can follow that for docker container? I'm sorry I'm not the most experienced with docker.
How can I correctly restore the database so the latest immich version will launch?
I can provide any more information that is needed, and any help would be greatly appreciated.
