ERROR_KNOWLEDGE_BANK_PGVECTOR_EXTENSION_NOT_AVAILABLE: pgvector extension is not available

The pgvector extension is missing on the PostgreSQL database. This happens when you try to use a PostgreSQL database for a Knowledge Bank, but it lacks the pgvector extension required for this.

Remediation

This issue can only be fixed by an administrator of the postgreSQL database.

First, install the pgvector extension on the PostgreSQL host. Then, enable the extension on the required database by running this SQL command: CREATE EXTENSION vector;