Use postgres DB with ssl

1

Hello,
I am trying to setup home assistant to use an external postgres DB with SSL.
I have in configuration.yaml the following string:

recorder:
  purge_keep_days: 5
  db_url: postgresql://<db_user>:<db_pass>@<db_url>:5433/homeassistant_db?ssl=true&sslmode=verify-full&sslrootcert=/config/root.crt

But i get the following error when i start home assistant.

2022-10-14 06:54:22.649 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (psycopg2.ProgrammingErr
or) invalid dsn: invalid connection option "ssl"

Is connection with SSL not supported?