I attached the script I am using to restore all of my databases I specified from across all my services, here is the relevent part: https://pastebin.com/KXUX4En3 ^ this is what backs up to immich, however, despite getting these logs of the data transfer going overall good https://pastebin.com/rN45hJQW This is the main bit:
(1 row)immich=# exitroot@immich-postgres-0:/# psql -U immich -d immichWARNING: database "immich" has a collation version mismatchDETAIL: The database was created using collation version 2.41, but the operating system provides version 2.36.HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.psql (15.12 (Debian 15.12-1.pgdg120+1))Type "help" for help.immich=#
(1 row)immich=# exitroot@immich-postgres-0:/# psql -U immich -d immichWARNING: database "immich" has a collation version mismatchDETAIL: The database was created using collation version 2.41, but the operating system provides version 2.36.HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.psql (15.12 (Debian 15.12-1.pgdg120+1))Type "help" for help.immich=#
is this why my data isnt showing in the actual immich dashboard? the version mismatch? How do i fix the version mismatch
Also this is kubernetes, but just treat the kubectl exec the same as docker exec