From ab9d9f9c2fb0669694a1552248d82421cb6bbe7e Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Mon, 27 Jul 2026 16:11:35 +0100
Subject: [PATCH] Allow planetdump to read sequences for tables it can read

---
 cookbooks/db/recipes/master.rb | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/cookbooks/db/recipes/master.rb b/cookbooks/db/recipes/master.rb
index aa9ff643f..abfe1e4ed 100644
--- a/cookbooks/db/recipes/master.rb
+++ b/cookbooks/db/recipes/master.rb
@@ -119,16 +119,21 @@ CGIMAP_PERMISSIONS = {
 
 PLANETDUMP_PERMISSIONS = {
   "changeset_comments" => :select,
+  "changeset_comments_id_seq" => :select,
   "changeset_tags" => :select,
   "changesets" => :select,
+  "changesets_id_seq" => :select,
   "node_tags" => :select,
   "nodes" => :select,
   "note_comments" => :select,
+  "note_comments_id_seq" => :select,
   "notes" => :select,
+  "notes_id_seq" => :select,
   "relation_members" => :select,
   "relation_tags" => :select,
   "relations" => :select,
   "users" => :select,
+  "users_id_seq" => :select,
   "way_nodes" => :select,
   "way_tags" => :select,
   "ways" => :select
@@ -271,6 +276,7 @@ end
     permissions "openstreetmap" => [:all],
                 "rails" => [:usage],
                 "cgimap" => CGIMAP_PERMISSIONS[sequence],
+                "planetdump" => PLANETDUMP_PERMISSIONS[sequence],
                 "backup" => [:select],
                 "grant" => [:select]
   end
-- 
2.47.3