[GH-ISSUE #4429] [BUG]: PG Vector Embedding Error (type "vector" does not exist) #2824

Closed
opened 2026-02-22 18:31:26 -05:00 by yindo · 0 comments
Owner

Originally created by @angelplusultra on GitHub (Sep 23, 2025).
Original GitHub issue: https://github.com/Mintplex-Labs/anything-llm/issues/4429

Originally assigned to: @angelplusultra on GitHub.

How are you running AnythingLLM?

All versions

What happened?

After setting the vector database to PG Vector and attempting to vectorize a document, I get this error:

Image

This is happening because by default, a PG database w/ PG Vector does not have the plugin enabled. It must be explicit enabled with the SQL command CREATE EXTENSION vector

Potential Fix:

When attempting to embed a document, first run a CREATE EXTENSION IF NOT EXISTS vector SQL command to ensure the PG Vector plugin is enabled on their database before proceeding.

https://github.com/Mintplex-Labs/anything-llm/blob/9466f671620366272228cfcc43d015aa7251a28d/server/utils/vectorDbProviders/pgvector/index.js#L406-L410

Are there known steps to reproduce?

No response

Originally created by @angelplusultra on GitHub (Sep 23, 2025). Original GitHub issue: https://github.com/Mintplex-Labs/anything-llm/issues/4429 Originally assigned to: @angelplusultra on GitHub. ### How are you running AnythingLLM? All versions ### What happened? After setting the vector database to PG Vector and attempting to vectorize a document, I get this error: <img width="966" height="312" alt="Image" src="https://github.com/user-attachments/assets/723f633e-72e9-48e8-bd48-3c7b4adbca00" /> This is happening because by default, a PG database w/ PG Vector does not have the plugin enabled. It must be explicit enabled with the SQL command `CREATE EXTENSION vector` Potential Fix: When attempting to embed a document, first run a `CREATE EXTENSION IF NOT EXISTS vector` SQL command to ensure the PG Vector plugin is enabled on their database before proceeding. https://github.com/Mintplex-Labs/anything-llm/blob/9466f671620366272228cfcc43d015aa7251a28d/server/utils/vectorDbProviders/pgvector/index.js#L406-L410 ### Are there known steps to reproduce? _No response_
yindo added the possible bugcore-team-only labels 2026-02-22 18:31:26 -05:00
yindo closed this issue 2026-02-22 18:31:26 -05:00
yindo changed title from [BUG]: PG Vector Embedding Error (type "vector" does not exist) to [GH-ISSUE #4429] [BUG]: PG Vector Embedding Error (type "vector" does not exist) 2026-06-05 14:48:46 -04:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Mintplex-Labs/anything-llm#2824