How to specify the SSL certificate for connecting to a postgres DB that requires SSL connections

[stbaldwin-trevipay]

I want to have a keda ScaledObject connect to a postgres DB that requires connecting with PGSSLMODE=verify-full. I can obviously set sslmode, but how or where do I define the root certificate?

Maybe I missed it, but I couldn't see any reference to this in the keda docs for the postgres scaler.

[stbaldwin-trevipay]

Never mind. I looked at the source and as far as I could tell, there is no way to define the equivalent of PGSSLROOTCERT. I switched to using require for sslmode and it works ok.