Allow promscale to manage the postgres extensions

diff --git a/cookbooks/prometheus/recipes/server.rb b/cookbooks/prometheus/recipes/server.rb
index d21227ee80e6152ca53b4a6acc78a005c65d2782..612b404cb30874089d1219e8375bf758cc63f25c 100644 (file)
--- 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"