PostgreSQL SSL connection

[mts-dyt]

Hello bentoml team 👋

I am trying to build a Yatai production ready platform on AZURE.
The database is hosted on an external Azure Postgres Single server but I am unable to configure the connection to the db because of the ssl mode.
In Production environment, our security policies only allow connection with SSL: sslmode=require but the Postgres connection string can only use non-ssl connection as it seems to be hard-coded here:

Yatai/api-server/services/db.go

Line 82 in 6916b93

uri := fmt.Sprintf("postgres://%s:%s@%s:%d/%s?sslmode=disable",

Is it possible to have an option to select the SSL mode pour the PG connection?

[yubozhao]

@mts-dyt Yep. We will try to get this issue resolved soon

[yetone]

@mts-dyt Thanks for your report again! I have added a helm chart value to set the sslmode of PostgreSQL, you can install v0.3.9 to use it. https://github.com/bentoml/yatai-chart/blob/main/values.yaml#L47