Caused by Discourse AI: == 20240611170904 UpgradePgvector070: migrating =============================== rake aborted! StandardError: An error has occurred, this and all later migrations canceled: (StandardError) ERROR: syntax error at or near "(" /home/robert/discourse/lib/mini_sql_multisite_connection.rb:109:in `run' /home/robert/discourse/plugins/discourse-ai/db/migrate/20240611170904_upgrade_pgvector_070.rb:10:in `up' /home/robert/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `block in exec_migration' /home/robert/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `exec_migration' /home/robert/discourse/lib/migration/safe_migrate.rb:28:in `migrate' I don’t use the plugin but it’s now bundled. Anyone solved this before?

It’s my version of Postgres I believe, I’ll try to upgrade

Upgrading PostgreSQL will resolve the issue, as the current version doesn’t support the syntax used by the pgvector extension in this migration.

We also need to upgrade PostgreSQL when going to 3.5, besides installing the pgvector extension? What is the minimum required PostgreSQL version?

I moved to 16, but 13 might suffice.

I don’t understand this topic. That migration runs fine on PG13.

I was running 12 :). But thanks for confirmation.

שגיאת העברת מפתח

מפתח

RGJ (Richard - Communiteq) 28 ביולי,‏ 2025,‏ 1:39pm 6

אני לא מבין את הנושא הזה. ההגירה הזו פועלת בסדר ב-PG13.

נושא		תגובות	צפיות
Extension "vector" has no update path from version "0.4.1" to version "0.7.0" (PG::InvalidParameterValue) Self-hosting	3	309	12 באוגוסט,‏ 2024
Is it safe to upgrade pgvector to 0.8.0 before running migration 20251007123645? Self-hosting	1	135	23 בפברואר,‏ 2026
Upgrade failed. Database stopped. (multisite install) Self-hosting	18	750	2 בנובמבר,‏ 2025
Broken update: ERROR: must be owner of extension vector (PG::InsufficientPrivilege) Bug ai , fixed	12	588	11 באוגוסט,‏ 2024
Can't restore database because migration in the database was in the (missing) discourse-ai plugin Development	2	480	25 במרץ,‏ 2024