[Feature]: Support trusted ca certificates

[weiss-m]

Is there an existing issue already for this feature request/idea?

• I have searched for an existing issue, and could not find anything. I believe this is a new feature request to be evaluated.

What problem is this feature going to solve? Why should it be added?

It is only supported to use self-signed server and, or client certificates.

https://cloudnative-pg.io/documentation/1.22/certificates/

Describe the solution you'd like

I would like to use trusted ca certificates.
E.g. Certificates issued by letcsencrypt (cert-manager)

Describe alternatives you've considered

Terminate TLS connection on ingress controller.

Additional context

Application requires trusted ca certificates to connect to database. Self-signed certificates are not supported.

Backport?

N/A

Are you willing to actively contribute to this feature?

No

Code of Conduct

• I agree to follow this project's Code of Conduct

[weiss-m]

related #3503