vector store configuration error

[SmallGaoX]

🐛 Describe the bug

After the "sslmode": "disable" configuration is added, an error will be reported, and no error will be reported if it is not added (although it is the same by default), dbname and sslmode will be passed to psycopg2.connect as parameters, resulting in an error, and no error will be reported if it is not added.

error connecting in 'pool-1': connection failed: connection to server at "127.0.0.1", port 5432 failed: FATAL:  database "storyforge_db sslmode=disable" does not exist
Multiple connection attempts failed. All failures were:
- host: 'localhost', port: '5432', hostaddr: '::1': connection failed: connection to server at "::1", port 5432 failed: FATAL:  database "storyforge_db sslmode=disable" does not exist
- host: 'localhost', port: '5432', hostaddr: '127.0.0.1': connection failed: connection to server at "127.0.0.1", port 5432 failed: FATAL:  database "storyforge_db sslmode=disable" does not exist
error connecting in 'pool-1': connection failed: connection to server at "127.0.0.1", port 5432 failed: FATAL:  database "storyforge_db sslmode=disable" does not exist

[SmallGaoX]

uv pip show mem0ai
Name: mem0aiow mem0ai                                                                                                                                                                                                                                                                                           

Version: 0.1.117
Location: venv/lib/python3.12/site-packages
Requires: openai, posthog, protobuf, pydantic, pytz, qdrant-client, sqlalchemy
Required-by:

[parshvadaftari]

@SmallGaoX We are using psycopg3 and not psycopg2. You can try updating your pscyopg package and check again. sslmode config also will depend on your DB config.