My team and I are trying to encrypt the connection between our AWS RDS Postgres 15 DB and Flyte for compliance purposes. Disabling SSL is not an option. We're stuck with this message:

[error] failed to initialize database, got error failed to connect to `host=<redacted> user=postgres database=datacatalog`: server error (FATAL: no pg_hba.conf entry for host "10.<redacted>", user "postgres", database "datacatalog", no encryption (SQLSTATE 28000))

We already tried setting

sslmode=require

as suggested here and setting

sslmode=verify-full

as suggested here and we get the same error, any suggestions? (cross posted in #ask-the-community https://flyte-org.slack.com/archives/CP2HDHKE1/p1712013097916879)