PostgresSQL Storage

[yitzchokneuhaus1]

Hello Team.
Does anyone know if Jaeger natively supports Postgres as a storage. ChatGPT speaks of it as if it exists. I followed the instructions but of course not table or data got created in my PostgreSQL db. Any advise is much appreciated

[dosubot[bot]]

Hello @yitzchokneuhaus1! I'm here to help you with any bugs or questions you have. Let's get to the bottom of this together.

Jaeger does support PostgreSQL as a storage backend, but not natively. It uses Promscale, which is a Jaeger and Prometheus storage backend built on PostgreSQL. Promscale implements the read path of Jaeger's Remote Storage API, allowing it to be used as a backend with Jaeger Query. However, it does not implement the write path, so trace ingestion must be done via the OpenTelemetry Collector using the OpenTelemetry Protocol (OTLP) ^[1][2].

To set this up, you need to configure Jaeger to use grpc-plugin as the storage type and deploy Promscale as a remote gRPC server. Ensure that your OpenTelemetry Collector is correctly configured to send traces to Promscale ^[2].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[jkowall]

Promscale is deprecated so there is not really a good option. I don't understand why you need postgresql for chatgpt? Can you explain what you are trying to do.

[yitzchokneuhaus1]

I am trying to persist the Jaeger metrics to a storage, so logs stay around even on server restarts. we have a very limited infrastructure. we do not currently have Docker or Kubernetes in our infrastructure. And we are running it on windows. I have PostgreSQL running. And I want Jaeger to push logs to that DB. Can you help me with that.

[yurishkuro]

All unofficial backends and their status can be tracked from this issue: #638.

[yurishkuro]

There are several efforts for PostgreSQL listed in the dedicated issue #1895