How to enable ssl on postgres sink

[UpilKodok]

Question

Do we have any way to enable ssl on postgres sink?
It seems using the endpoint path sslmode=required is not working, given the logs below
I'm using this tag from Docker image distribution 0.46.1-alpine

Vector Config

postgres:
        type: postgres
        inputs:
          - parse_json
        endpoint: postgres://{{ .Values.timescale.env.user }}:{{ .Values.timescale.env.password }}@{{ template "osuite.timescale.fullname" . }}:{{ .Values.timescale.service.port }}/{{ .Values.timescale.env.db }}?sslmode=require
        table: logs

Vector Logs

2025-08-04T07:33:15.304224Z INFO vector::app: Loading configs. paths=["/etc/vector/vector.yaml"]
2025-08-04T07:33:15.365918Z ERROR vector::topology::builder: Configuration error. error=Sink "postgres": error occurred while attempting to establish a TLS connection: TLS upgrade required by connect options but SQLx was built without TLS support enabled

[thomasqueirozb]

Hi are you able to test it using the latest version of Vector? It may be that a feature was missed when updating the sqlx dependency

[UpilKodok]

Hi, I tried using version 0.48.0, but it still has the same problem with sqlx

[thomasqueirozb]

Thanks for checking! I just created #23536 which should fix this 🤞

I haven't tested it yet and therefore still in draft but I will mark it as ready as soon as I have some time to set up a local TLS-enabled Postgres environment. I know it's a bit of a hassle but you can checkout that branch locally and compile vector for yourself and test it out while that PR is still in draft if you'd like

[UpilKodok]

Thank you for the help :) Sure, I'd like to try to test it