Still an issue: ERROR: must be owner of extension vector

[ja3 (Ja)]

There has been a few threads about this issue, which includes responses from the contributors that the issue has been fixed in docker_manager.

But I still have this issue running launcher rebuild app. I use a single container (on a linux VM), and the database is hosted on Azure Postgresql Flexible Server.

Further down…

Final summary

Has anyone managed to figure out a solution with this setup (Azure Postgresql) ?

PS: I’m continuing to run discourse with the AI plugin disabled for now.

[Falco]

@ja3

the database is hosted on Azure Postgresql Flexible Server.

If the user you have configured for this database isn’t the owner of the extension, it will fail with the message shared above: ERROR: must be the owner of the extension vector.

To workaround this issue, log to the database directly with the user who is the owner and run ALTER EXTENSION vector UPDATE TO '0.7.0';.

[ja3 (Ja)]

Thanks @Falco that solved the issue for me!

Since Azure doesn’t allow specifying the version I ran ALTER EXTENSION vector UPDATE to update to the latest available version. The extension installs are specific to the database, so need to connect to the discourse database (not the default postgres db) to run the update statement.

Here’s how to check the current installed version and to update.

SELECT name, default_version, installed_version FROM pg_available_extensions WHERE name = 'vector';