Steps to reproduce:
- In compose.env, set POSTGRES_PASSWORD=password; POSTGRES_USER=postgres; POSTGRES_DB=mydb.
- Start the developer RAG with docker-compose-pgvector.yaml
- On the developer RAG UI, swith to the 'kb' page, click 'Add file' to upload a pdf file.
- Connect to the created pgvector database with UI tools like 'pgAdmin'. Check the vector data written to the database.
Problem description: vector data was not written to the user speicified database 'mydb', but written to another database named 'vector_db'. And it seems the name 'vector_db' is hard-coded.
Expected result: vector data should be written to the database user specified in the compose.env file.