Connecting TimescaleDB to Signoz

TLDR Milan needed help connecting TimescaleDB to Signoz for monitoring parameters. Ankit advised using Prometheus integration with modifications to the prometheus.yml file.

Photo of Milan
Milan
Tue, 09 May 2023 08:06:30 UTC

Hi all, I need help understanding what would be recommended way to connect TimscaleDB () instance to Signoz. This image shows available options from TimescaleDB: Thanks in advance

Photo of Ankit
Ankit
Tue, 09 May 2023 09:12:43 UTC

are you using timescaledb saas or self-host?

Photo of Ankit
Ankit
Tue, 09 May 2023 09:12:59 UTC

and, why do you need to connect timescaledb to signoz?

Photo of Milan
Milan
Tue, 09 May 2023 09:13:00 UTC

saas

Photo of Milan
Milan
Tue, 09 May 2023 09:13:38 UTC

I want to be able to monitor parameters like cpu usage, free hdd space and similar

Photo of Ankit
Ankit
Tue, 09 May 2023 09:15:44 UTC

ok... since they are timeseriesDB they should have shown it themselves, i.e., another account should show these metrics from the other account.

Photo of Ankit
Ankit
Tue, 09 May 2023 09:17:05 UTC

I think this integration is something specific to them that we do not control. If they were exposing OpenTelemetry format data, then it should be possible.

Photo of Ankit
Ankit
Tue, 09 May 2023 09:17:28 UTC

Let me quickly check if it would be possible to use their Prometheus integration

Photo of Ankit
Ankit
Tue, 09 May 2023 09:20:39 UTC

You should be able to do this by using prometheus integration ```# prometheus.yml for monitoring a Timescale Cloud instance global: scrape_interval: 10s evaluation_interval: 10s scrape_configs: - job_name: prometheus scheme: https static_configs: - targets: ['{TARGET_IP}:{TARGET_PORT}'] tls_config: insecure_skip_verify: true basic_auth: username: {ENDPOINT_USERNAME} password: {ENDPOINT_PASSWORD} remote_write: - url: "http://{ADAPTER_IP}:9201/write" remote_read: - url: "http://{ADAPTER_IP}:9201/read"```

Photo of Ankit
Ankit
Tue, 09 May 2023 09:21:18 UTC

How to enable prometheus receiver at SigNoz

Photo of Milan
Milan
Tue, 09 May 2023 09:22:09 UTC

Thanks a lot.

Photo of Ankit
Ankit
Tue, 09 May 2023 09:24:23 UTC

you won't need ```remote_write: - url: "http://{ADAPTER_IP}:9201/write" remote_read: - url: "http://{ADAPTER_IP}:9201/read"```