+package %w[
+ prometheus
+ prometheus-alertmanager
+]
+
+promscale_version = "0.6.2"
+
+database_version = node[:timescaledb][:database_version]
+database_cluster = "#{database_version}/main"
+
+postgresql_user "prometheus" do
+ cluster database_cluster
+ superuser true
+end
+
+postgresql_database "promscale" do
+ cluster database_cluster
+ owner "prometheus"
+end
+
+directory "/opt/promscale" do
+ owner "root"
+ group "root"
+ mode "755"
+end
+
+cookbook_file "/usr/lib/postgresql/#{database_version}/lib/promscale.so" do
+ source "postgresql-#{database_version}-promscale.so"
+ owner "root"
+ group "root"
+ mode "644"
+end
+
+directory "/opt/promscale/bin" do
+ owner "root"
+ group "root"
+ mode "755"
+end
+
+remote_file "/opt/promscale/bin/promscale" do
+ action :create
+ source "https://github.com/timescale/promscale/releases/download/#{promscale_version}/promscale_#{promscale_version}_Linux_x86_64"
+ owner "root"
+ group "root"
+ mode "755"
+end
+
+systemd_service "promscale" do
+ description "Promscale Connector"
+ type "simple"
+ user "prometheus"
+ exec_start "/opt/promscale/bin/promscale --db-uri postgresql:///promscale?host=/run/postgresql&port=5432 --db-connections-max 400"
+ # exec_start lazy { "/opt/promscale/bin/promscale --db-host /run/postgresql --db-port #{node[:postgresql][:clusters][database_cluster][:port]} --db-user prometheus --db-name promscale --db-max-connections 400" }
+ limit_nofile 16384
+ private_tmp true
+ protect_system "strict"
+ protect_home true
+ no_new_privileges true
+end
+
+service "promscale" do
+ action [:enable, :start]
+ subscribes :restart, "remote_file[/opt/promscale/bin/promscale]"
+ subscribes :restart, "systemd_service[promscale]"
+end
+
+systemd_service "promscale-maintenance" do
+ description "Promscale Maintenance"
+ type "simple"
+ user "prometheus"
+ exec_start "/usr/bin/psql --command='CALL prom_api.execute_maintenance()' promscale"
+ private_tmp true
+ protect_system "strict"
+ protect_home true
+ no_new_privileges true
+end
+
+systemd_timer "promscale-maintenance" do
+ description "Promscale Maintenace"
+ on_active_sec 1800
+ on_unit_inactive_sec 1800
+end
+
+service "promscale-maintenance.timer" do
+ action [:enable, :start]
+end
+
+search(:node, "roles:gateway") do |gateway|
+ allowed_ips = gateway.interfaces(:role => :internal).map do |interface|
+ "#{interface[:network]}/#{interface[:prefix]}"
+ end
+
+ node.default[:networking][:wireguard][:peers] << {
+ :public_key => gateway[:networking][:wireguard][:public_key],
+ :allowed_ips => allowed_ips,
+ :endpoint => "#{gateway.name}:51820"
+ }
+end