From 3fff7361f2ebbf7a20cbe12f4d45194c039e7dae Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Tue, 13 Jan 2026 19:29:02 +0000 Subject: [PATCH] Install btree_gist owned by the apis user for dev instances --- cookbooks/dev/recipes/default.rb | 1 + cookbooks/postgresql/resources/extension.rb | 3 ++- 2 files changed, 3 insertions(+), 1 deletion(-) 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 -- 2.39.5