Can Pgwatch use both Postgres and Prometheus as data sources at the same time?

[emreyaniktr]

Hello, I am using the Docker version of Pgwatch. By default, metrics are stored on Postgres. I would like to write the metrics to Prometheus as well, simultaneously. Is this possible? Or can the metrics only be written to a single data source at a time?

[ondar]

Yes, it is possible, we use it like that. You can se how: #569 (comment)

[pashagolub]

If you see any errors during the docker container restart, please delete all containers and volumes you created before.

[pashagolub]

Please check https://github.com/cybertec-postgresql/pgwatch/blob/master/docker/compose.pgwatch.yml to see how to run several sinks

[emreyaniktr]

When uninstalling with Compose, it creates a separate container for each service. I have a large data center. And I work on many pgwatch containers. Creating a separate container for each service is very complicated for me.

[pashagolub]

I see. Then use only cybertecpostgresql/pgwatch container. This is the only container one should use for production.

We are more than happy to help you with deployments. Please, see our services.

[emreyaniktr]

cybertecpostgresql/pgwatch is there only pgwatch service in this image or Grafana+postgres+pgwatch services? Like in pgwatch-demo. Can I do multi-sink with this image? I need an example, I tried too hard

[pashagolub]

Yes, we call them data sinks. Data sources are what we are monitoring: databases, pgpool, pggbouncer, etc.

[emreyaniktr]

Hello, I want the collected metrics to be stored on both postgres and prometheus, not the data sources we monitor.

[pashagolub]

I know! You have an error in your question. I corrected it