From: Tom Hughes <tom@compton.nu>
Date: Tue, 13 Jan 2026 19:29:02 +0000 (+0000)
Subject: Install btree_gist owned by the apis user for dev instances
X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain

Install btree_gist owned by the apis user for dev instances
---

diff --git a/cookbooks/dev/recipes/default.rb b/cookbooks/dev/recipes/default.rb
index 98e9ff068..ff2c60b9e 100644
--- a/cookbooks/dev/recipes/default.rb
+++ b/cookbooks/dev/recipes/default.rb
@@ -367,6 +367,7 @@ if node[:postgresql][:clusters][rails_cluster.to_sym]
         cluster rails_cluster
         database database_name
         extension "btree_gist"
+        owner "apis"
       end
 
       directory site_directory do
diff --git a/cookbooks/postgresql/resources/extension.rb b/cookbooks/postgresql/resources/extension.rb
index ec60fb975..1a8c83e43 100644
--- a/cookbooks/postgresql/resources/extension.rb
+++ b/cookbooks/postgresql/resources/extension.rb
@@ -24,11 +24,12 @@ default_action :create
 property :extension, :kind_of => String, :name_property => true
 property :cluster, :kind_of => String, :required => true
 property :database, :kind_of => String, :required => true
+property :owner, :kind_of => String
 
 action :create do
   unless cluster.extensions(new_resource.database).include?(new_resource.extension)
     converge_by "create extension #{new_resource.extension}" do
-      cluster.execute(:command => "CREATE EXTENSION #{new_resource.extension}", :database => new_resource.database)
+      cluster.execute(:command => "CREATE EXTENSION #{new_resource.extension}", :database => new_resource.database, :user => new_resource.owner)
     end
   end
 end