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.
Validated on 20 Nov 2024 • Last edited on 17 Apr 2025
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.
Add the –no-role-passwords flag to the pg_dumpall command.
Resolve the pg_dump server version mismatch by upgrading pg_dump, matching it to the server version, or using a third-party backup tool.
Verify the database cluster, username, and password.
Try using different keywords or simplifying your search terms.