Self Checks

• I have read the Contributing Guide and Language Policy.
• This is only for bug report, if you would like to ask a question, please head to Discussions.
• I have searched for existing issues search for existing issues, including closed ones.
• I confirm that I am using English to submit this report, otherwise it will be closed.
• 【中文用户 & Non English User】请使用英语提交，否则会被关闭 ：）
• Please do not modify this template :) and fill in all the required fields.

Dify version

1.7.2

Cloud or Self Hosted

Self Hosted (Docker)

Steps to reproduce

pg_vector extension requires SUPERUSER, but not available on Huawei Cloud RDS
https://support.huaweicloud.com/rds-pg_faq/rds_faq_0075.html

✔️ Expected Behavior

After using Huawei Cloud pg and installing the vector plugin, an error occurs when using the knowledge base function of the dify platform to transfer local files.
Prompt: psycopg2.errors.InsufficientPrivilege: permission denied to create access method “ivfflat”
Prompt: Only superusers can create access methods.

❌ Actual Behavior

No response