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?

i’m not sure, but i’m not sure this is flyte specific

This got resolved, I wasn't passing in the password properly, the password or passwordPath has to be specified in the db.yml configmap (if using the Helm chart, defined under

spec.db.<component, for example datacatalog>.database.password

or

spec.db.<component, for example datacatalog>.database.passwordPath