From a381c2d5be3c5aff896dcdd30c77c1abf3464cce Mon Sep 17 00:00:00 2001
From: Andy Allan <git@gravitystorm.co.uk>
Date: Wed, 11 Mar 2026 10:14:39 +0000
Subject: [PATCH] Add postgis to master database

---
 cookbooks/db/recipes/master.rb                       | 10 ++++++++++
 test/integration/db-master/inspec/postgresql_spec.rb |  4 ++++
 2 files changed, 14 insertions(+)

diff --git a/cookbooks/db/recipes/master.rb b/cookbooks/db/recipes/master.rb
index 80ef431a2..1e58a576d 100644
--- a/cookbooks/db/recipes/master.rb
+++ b/cookbooks/db/recipes/master.rb
@@ -67,6 +67,10 @@ postgresql_user "replication" do
   replication true
 end
 
+node[:postgresql][:versions].each do |version|
+  package "postgresql-#{version}-postgis-3"
+end
+
 postgresql_database "openstreetmap" do
   cluster node[:db][:cluster]
   owner "openstreetmap"
@@ -78,6 +82,12 @@ postgresql_extension "btree_gist" do
   only_if { node[:postgresql][:clusters][node[:db][:cluster]] && node[:postgresql][:clusters][node[:db][:cluster]][:version] >= 9.0 }
 end
 
+postgresql_extension "postgis" do
+  cluster node[:db][:cluster]
+  database "openstreetmap"
+  owner "postgres"
+end
+
 CGIMAP_PERMISSIONS = {
   "changeset_comments" => [:select],
   "changeset_tags" => [:select],
diff --git a/test/integration/db-master/inspec/postgresql_spec.rb b/test/integration/db-master/inspec/postgresql_spec.rb
index 4c5872e63..057ee37f7 100644
--- a/test/integration/db-master/inspec/postgresql_spec.rb
+++ b/test/integration/db-master/inspec/postgresql_spec.rb
@@ -2,6 +2,10 @@ describe package("postgresql-15") do
   it { should be_installed }
 end
 
+describe package("postgresql-15-postgis-3") do
+  it { should be_installed }
+end
+
 describe service("postgresql@15-main") do
   it { should be_enabled }
   it { should be_running }
-- 
2.47.3