prometheus-community / prometheus-community/postgres_exporter

pg_static checking targets in a series rather than parallel

Open
#756 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Go
Stars
3.6k
Forks
835
Avg merge
2d 4h
Merged PRs (30d)
10

Description

What did you do?
We run Postgres_Exporter in deployments in K8 targeting AWS/RDS endpoints. Each deployment targets several Postgres instances by their major version. We use the metric pg_static to test for availability. We have Alert Rules set up in Grafana to check UP/DOWN.

What did you expect to see?
If one Postgres instance is stopped then all others configured in the same deployment should still show available.

What did you see instead? Under which circumstances?
All Postgres instances/targets in the deployment showed "no data" and as a result alerts were triggered for database down. This remained until a restart of the deployment and/or a removal of the offending target.

Environment
AWS/RDS, Postgres v11, v12 and v13.

  • System information:

AWS K8 pod

  • postgres_exporter version:
    v0.10.1

  • postgres_exporter flags:

None

  • PostgreSQL version:

v11.9, 11.13, 11.16, 12.8, 13.4, 13.6, 13.7

  • Logs:

Will follow up with these when available

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No source file or test is identified in the issue. Start by reproducing the deployment with several PostgreSQL targets and one unavailable instance, then trace the pg_static collection path. Done means healthy targets still report availability when one target is stopped, and Grafana alerts distinguish each target correctly.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, go, kubernetes, postgresql
Domain
cloud, databases, observability
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.