For AI agents: The documentation index is at https://docs.digitalocean.com/llms.txt. Markdown versions of pages use the same URL with index.html.md in place of the HTML page (for example, append index.html.md to the directory path instead of opening the HTML document).

The PostgreSQL extension pgvector sometimes returns the following error when you run the command CREATE EXTENSION pgvector;:

ERROR: could not open extension control file "/usr/pgsql-16/share/extension/pgvector.control": No such file or directory

This is because, despite the project being named pgvector, the creation command requires that you use vector as the extension name, like so:

 
CREATE EXTENSION vector; 

For more details, see the pgvector documentation.

Related Topics

How do I fix a "permission denied for schema public" error in PostgreSQL?

Update the user’s privileges to CREATE, USAGE, or ALL on the public schema.

How do I fix the pg_dumpall "permission denied for table pg_authid" error?

Add the –no-role-passwords flag to the pg_dumpall command.

How do I fix the pg_dump "aborting because of server version mismatch" error?

Resolve the pg_dump server version mismatch by upgrading pg_dump, matching it to the server version, or using a third-party backup tool.