feat(ev): add minifluxHEADmaster

I already had a miniflux instance a couple years ago
but accidentally dropped the database.

1 files changed, 42 insertions, 0 deletions

diff --git a/nixos/hosts/ev/exporters.nix b/nixos/hosts/ev/exporters.nix
new file mode 100644
index 0000000..1c03c35
--- /dev/null
+++ b/nixos/hosts/ev/exporters.nix
@@ -0,0 +1,42 @@
+{ config, lib, pkgs, ... }:
+
+let
+  helpers = import <top/shared/postgres-collectors.nix> { inherit config lib pkgs; };
+  cfg = config.exporters;
+in
+{
+  options.exporters = {
+    sqlExporterPort = lib.mkOption {
+      type = lib.types.int;
+    };
+  };
+
+  imports = [
+    <top/shared/prometheus-sql-exporter/service.nix>
+  ];
+
+  config = {
+    services.prometheus-sql-exporter = {
+      enable = true;
+      port = cfg.sqlExporterPort;
+      config = {
+        target = {
+          # This URL should be postgresql:///postgres?host=/run/postgresql
+          # but sql_exporter uses xo/dburl which isn't spec-compliant: https://github.com/xo/dburl/issues/46
+          data_source_name = "postgresql:/run/postgresql:/postgres";
+          collectors = helpers.collectorNames;
+        };
+        collectors = helpers.collectors;
+      };
+    };
+
+    monitoring.prometheusScrapeConfigs = [
+      {
+        job_name = "sql";
+        static_configs = [{
+          targets = [ "localhost:${toString cfg.sqlExporterPort}" ];
+        }];
+      }
+    ];
+  };
+}