[bitnami/postgresql-ha] add a pgpool exporter

[DorBreger]

Name and Version

bitnami/postgresql-ha 13.4.5

What is the problem this feature will solve?

allow monitoring the pgools themselves, as monitoring only the postgres instances is half the story. What if the pgpools can't connect to the postgres pods? etc.

What is the feature you are proposing to solve the problem?

Add a pgpool exporter as a sidecar container, similar to what we have. I have tried working on this on my own, and will happily provide another PR if I receive some guidance. The pgpool's official exporter image is outdated, and currently immediately exits if it can't connect to the pgpool instance, causing the entire pod to fail. The code is fixed, we are just waiting for them to release it. I saw that most of the charts on this repository use container images from bitnami/containers, What is the process of submitting a new container there? This way we can simply build the image from the code directly, and not wait on the devs releasing it as a docker image.

Another smaller issue I have is whether now, because we have metric services for both the pgool and the postgres, should we have different metrics: sections in the values.yaml file? And should they be in the postgresql and pgpool sections respectively?
I would love to hear your input on the matter.

What alternatives have you considered?

No response

[javsalgar]

Hi!

Thank you so much for the request. I will forward it to the team for evaluation.

[colin719]

need this feature