Error creating vector storage: permission denied to create extension "vector"

Anyone seen this error before. I'm not able to get past this. Any help on how to resolve that is appreciated.

Update:
Error creating vector storage: could not open extension control file "/usr/share/postgresql/14/extension/vector.control": No such file or directory

Oscar

Hi @ohpreis,

Unfortunately I don't think I have seen that error message before :thinking:

Could you share a screenshot of the error?

Are you creating a vector from the GUI panel?

It sounds like the file path is incorrectly pointing to the wrong location while looking for a file. Not sure if the file needs to be moved or if the instructions on where the program should look for the file it needs should be changed :sweat_smile:

Are you are self hosting Retool?

Hi @ohpreis,

Just wanted to follow up to see if you are still getting this error message or if you have any more details you could share to help me troubleshoot!

Hi @Jack_T, thanks for reaching out. I was able to resolve this issue.

1 Like

@ohpreis Great to hear!

If you want to share how you resolved that issue, that may be helpful for any others that run into the same issue and are looking to solve it on the forum!

I can mark it as a solution so it is easy to find.

@ohpreis Was it related to permissions or file path routing?

If I remember that correctly it was related to permissions. I also had to first install the vector extension manually. There was an error something like the following. "Retool Error creating vector storage: permission denied to create extension "vector." Hope this helps.