Enabling `vector` in Prisma Postgres DB

I'm trying to enable pgvector in prisma postgres. Be it via running migration script or connecting to the db and executing the command:

CREAT EXTENSION vector;

CREAT EXTENSION vector;

it does not work. Instead, I just get this error:

ERROR: extension "vector" is not available
DETAIL: Could not open extension control file "/usr/local/share/postgresql/extension/vector.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.

ERROR: extension "vector" is not available
DETAIL: Could not open extension control file "/usr/local/share/postgresql/extension/vector.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.

Prisma•9mo ago•

6 replies

aith

Enabling `vector` in Prisma Postgres DB

I'm trying to enable pgvector in prisma postgres. Be it via running migration script or connecting to the db and executing the command:

CREAT EXTENSION vector;

CREAT EXTENSION vector;

it does not work. Instead, I just get this error:

ERROR: extension "vector" is not available
DETAIL: Could not open extension control file "/usr/local/share/postgresql/extension/vector.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.

ERROR: extension "vector" is not available
DETAIL: Could not open extension control file "/usr/local/share/postgresql/extension/vector.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.

Enabling `vector` in Prisma Postgres DB

Similar Threads

Enabling `vector` in Prisma Postgres DB

Similar Threads

Similar Threads

Similar Threads