Dev migration error: PGVector

Dev
1

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?

2

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

3

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

1 Like
4

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

5

I moved to 16, but 13 might suffice.

1 Like
6

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

1 Like
7

I was running 12 :).

But thanks for confirmation.