Created attachment 248382 [details] patch i'm rather surprised this wasn't already ported, but here's a Prometheus metric exporter for PostgreSQL databases. i've tested on 15.0/amd64, but should work anywhere as it's just ordinary Go stuff. includes rc.d script and basic setup instructions in pkg-message. portlint and testport passed.
i've named this 'postgres_exporter' after the pattern of existing ports like 'blackbox_exporter'. i think something like 'prometheus-postgres-exporter' would be nicer, following the example of e.g. net-mgmt/prometheus-collectd-exporter, but i'm not sure if there's any policy about this or a strong reason to prefer one of the other.
Discussed this with my mentors and was given the permission/directive to call the shot on PORTNAME myself: Let's go with prometheus-postgres-exporter.
sounds good; do you want a new patch or will you change that yourself?
I'd prefer if you can update the patch accordingly (and performing the usual QA).
Created attachment 248746 [details] patch new patch: renamed to prometheus-postgres-exporter testport, runtime tested on 13.2, 14.0, 15.0: service postgres_exporter enable; service postgres_exporter start; service returns an HTTP response. okay to commit.
Created attachment 250016 [details] patch same patch as before, rebase on current ports main to resolve conflicts.