Cause
- The migration tries to upgrade the “vector” extension.
- The PostgreSQL user running the migration (e.g. discourse) must be the owner of the extension, but it’s owned by a different user (often postgres).
Solution
- Connect to your database as the owner
- Run the update as the owner
Checkout the discussion on the same Still an issue: ERROR: must be owner of extension vector - #2 by Falco