SSL MODE error to postgresql

[LStromann]

=Hi guys!

I suspect that the changes in version 0.5.2, specifically using URL.create to generate the connection string, are not supporting SSL for PostgreSQL. I am having problems because of that, I use SSL mode for security.

I ask to Claude code if I can put SSL mode to URL.create, its answer:

# Instead of a simple string, ensure the 'sslmode' is part of the query
url = URL.create(
    "postgresql",
    username="user",
    password="password",
    host="localhost",
    database="vector_db",
    query={"sslmode": "require"}, #include that line
)

Code url: https://github.com/topoteretes/cognee/blob/main/cognee%2Finfrastructure%2Fdatabases%2Frelational%2Fcreate_relational_engine.py

This discussion was automatically pulled from Discord.

[LStromann]

thanks for sharing <@1364045658796986521> the current configuration only mention the basic postgres connection variables and don't list SSL options so I'm not sure if sslmode is currently supported through configuration

tagging the <@&1459132796818821192> here since they'll know whether SSL parameters are expected to be passed through URL.create or configured another way.

[LStromann]

Hi <@1364045658796986521> if you resolve the issue for yourself and test it and it works please open a PR on the Cognee side to make it able to work with ssl and without

We will review it and merge it for other users

[LStromann]

Ok, I will try 🙂