Postgres PGVector Store

Feature Requests
1

Node: Postgres PGVector Store

The idea is:

Coming from this GitHub issue: Postgres PGVector Store · Issue #15739 · n8n-io/n8n · GitHub
I did not create the issue there, but as it has not been opened as a feature request, at least I could not find it, I am opening it here.

The Request:

The Postgres PGVector Store imports the langchain_community.vectorstores.pgvector.PGVector object, with the default parameter create_extension=True. This requires admin privilages, which not all users should have, resulting in the error (even if the extension is already installed):

“”“Because vector isn’t a trusted extension, only members of “azure_pg_admin” are allowed to use CREATE EXTENSION vector”“”

Please add an option to disable the automatic creation of the extension in the n8n node.

My use case:

As a non-admin user of a postgres database, I want to use any of the Postgres PGVector Store functionalities.

I think it would be beneficial to add this because:

This change would allow non-admin database users to utilize the PGVector Store node. It is generally considered best practice to avoid having an admin database user perform such tasks. Instead, it is safer and more efficient to assign a user with a specific role to act on behalf of the workflow.

Any resources to support this?

Are you willing to work on this?

I do not have much capacity atm, sorry.

Thanks a lot in advance, it would really be neat to get this going soon :raising_hands:

2

@thomasender have you found any workaround to this issue?

3

No. The only way to currently make this work is to give the necessary db right to the user.

4

one possible route might be to create a custom node of Postgres PGVector Store where one have the possibility to disable table creation and handle that on the side.

5

Anyone find a fix for this? Running into this problem right now. Some have mentioned this if else block addition but can’t modify the underlying postgres vector node in n8n…