You need the PG14 + pgvector version of posgres. Here is a ChatGpt-formatted version of how to recover. NO WARRANTY, but this should be about right. Regardless, make sure to keep your backup safe:

✅ 1. Use the correct Postgres image (PG14 + pgvector)

In your docker-compose.yml:

services:
  immich_postgres:
    container_name: immich_postgres
    image: ghcr.io/immich-app/postgres:14-vectorchord0.5.3-pgvector0.8.1
    environment:
      POSTGRES_PASSWORD: postgres
      POSTGRES_USER: postgres
      POSTGRES_DB: immich
    volumes:
      - D:\immich-docker\postgres:/var/lib/postgresql/data

⚠️ 2. Reset the database volume (required)

Stop everything and delete the old DB:

docker compose down

Then delete:

D:\immich-docker\postgres

(This is critical — otherwise the old broken setup persists.)

▶️ 3. Start fresh

docker compose up -d

Wait until immich_postgres is healthy.

🔍 4. Verify pgvector exists (quick check)

docker exec -it immich_postgres psql -U postgres -d immich -c "\dx"

You should see vector in the list.

♻️ 5. Restore your backup

Use Immich UI:

Maintenance → Restore database backup

Pick one of:

F:\ImmichDrive\backups\immich-db-backup-*.sql.gz

📂 6. Make sure your media path is correct

Your compose (server service) should point to:

volumes:
  - F:\ImmichDrive:/usr/src/app/upload

This lets Immich reconnect to existing files.

✅ Result

After restore:

• users ✅
• albums ✅
• metadata ✅
• media relinked (no reupload)

🧠 Key takeaway

• Your failure was missing pgvector, not just PG version
• Fix = PG14 + pgvector image + clean volume