PW_SINK with hostssl=require

[seanzechman]

I believe PW_SINK is equivalent to PW2_PG_METRIC_STORE_CONN_STR from pgwatch2 - the connection string for the metricstore. Our goal is to force all connections to be ssl and we have configured our hba as such. However, the metric store connection does not work. Is there a way to make this work?

I tried below two options to no avail:

Environment="PW2_PG_METRIC_STORE_CONN_STR=postgresql://pgwatch2@servername:5432/pgwatch2_metrics hostssl=require"

Environment="'PW2_PG_METRIC_STORE_CONN_STR=postgresql://pgwatch2@servername:5432/pgwatch2_metrics hostssl=require'"

Environment="PW2_PG_METRIC_STORE_CONN_STR="postgresql://pgwatch2@servername:5432/pgwatch2_metrics hostssl=require""

I also tried adding this
Environment="PGSSLMODE=require"

[pashagolub]

How about --sink=postgresql://pgwatch2@servername:5432/pgwatch2_metrics?sslmode=require?

[seanzechman]

That worked! Thank you so much