Hey there, I am trying to migrate a previous immich install on docker, however, the database is failing as such
postgresql.service - PostgreSQL Server
Loaded: loaded (/etc/systemd/system/postgresql.service; enabled; preset: ignored)
Active: active (running) since Sun 2024-12-08 19:36:07 WET; 9s ago
Invocation: e47fdc853d264fc9839a3efe9c5feefa
Process: 74178 ExecStartPre=/nix/store/hd8hxdfwgnsd5vgdq94lw84jpv3rpyv3-unit-script-postgresql-pre-start/bin/postgresql-pre-start (code=exited, status=0/SUCCESS)
Process: 74193 ExecStartPost=/nix/store/61pypd3h139syfxzm53jl9nbf1p5ksc5-unit-script-postgresql-post-start/bin/postgresql-post-start (code=exited, status=0/SUCCESS)
Process: 74197 ExecStartPost=/nix/store/w4aryg759d7xfjmzv20qmivkyh0k6aak-postgresql-15.9/bin/psql -d immich -f /nix/store/hqi4c0qrrwkm7l6higrb709si7z983p4-immich-pgvectors-setup.sql (code=exited, status=0/SUCCESS)
Main PID: 74180 (postgres)
IP: 0B in, 0B out
IO: 0B read, 380K written
Tasks: 11 (limit: 18031)
Memory: 22.9M (peak: 29M)
CPU: 146ms
CGroup: /system.slice/postgresql.service
├─74180 /nix/store/j54b9h6pja78b13cfs480x75fricvpx4-postgresql-and-plugins-15.9/bin/postgres
├─74182 "postgres: checkpointer "
├─74183 "postgres: background writer "
├─74185 "postgres: vectors "
├─74190 "postgres: walwriter "
├─74191 "postgres: autovacuum launcher "
└─74192 "postgres: logical replication launcher "
dez 08 19:36:07 nixos postgres[74256]: [74256] ERROR: relation "pg_vector_index_stat" does not exist at character 24
dez 08 19:36:07 nixos postgres[74256]: [74256] STATEMENT: SELECT idx_status FROM pg_vector_index_stat WHERE indexname = $1
dez 08 19:36:07 nixos postgres[74256]: [74256] ERROR: permission denied for schema public
dez 08 19:36:07 nixos postgres[74256]: [74256] STATEMENT: ALTER TABLE naturalearth_countries ALTER id ADD GENERATED ALWAYS AS IDENTITY
dez 08 19:36:13 nixos postgres[74340]: [74340] ERROR: relation "pg_vector_index_stat" does not exist at character 24
dez 08 19:36:13 nixos postgres[74340]: [74340] STATEMENT: SELECT idx_status FROM pg_vector_index_stat WHERE indexname = $1
dez 08 19:36:13 nixos postgres[74340]: [74340] ERROR: relation "pg_vector_index_stat" does not exist at character 24
dez 08 19:36:13 nixos postgres[74340]: [74340] STATEMENT: SELECT idx_status FROM pg_vector_index_stat WHERE indexname = $1
dez 08 19:36:13 nixos postgres[74340]: [74340] ERROR: permission denied for schema public
dez 08 19:36:13 nixos postgres[74340]: [74340] STATEMENT: ALTER TABLE naturalearth_countries ALTER id ADD GENERATED ALWAYS AS IDENTITY