From: Tom Hughes <tom@compton.nu>
Date: Thu, 4 Mar 2021 19:27:43 +0000 (+0000)
Subject: Allow promscale to manage the postgres extensions
X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain/a8151a769c86a3f482651f2b82c463bab1c0261e

Allow promscale to manage the postgres extensions
---

diff --git a/cookbooks/prometheus/recipes/server.rb b/cookbooks/prometheus/recipes/server.rb
index d21227ee8..612b404cb 100644
--- a/cookbooks/prometheus/recipes/server.rb
+++ b/cookbooks/prometheus/recipes/server.rb
@@ -43,7 +43,7 @@ database_cluster = "#{node[:timescaledb][:database_version]}/main"
 
 postgresql_user "prometheus" do
   cluster database_cluster
-  createrole true
+  superuser true
 end
 
 postgresql_database "promscale" do
@@ -51,11 +51,6 @@ postgresql_database "promscale" do
   owner "prometheus"
 end
 
-postgresql_extension "timescaledb" do
-  cluster database_cluster
-  database "promscale"
-end
-
 directory "/opt/promscale" do
   owner "root"
   group "root"
@@ -121,12 +116,6 @@ service "promscale" do
   subscribes :restart, "systemd_service[promscale]"
 end
 
-postgresql_extension "promscale" do
-  cluster database_cluster
-  database "promscale"
-  notifies :restart, "service[promscale]"
-end
-
 systemd_service "promscale-maintenance" do
   description "Promscale Maintenace"
   type "simple"