From 550ecbbcd2d92761ff266932f61e84adde1b5d89 Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Sun, 12 Jul 2026 11:40:13 +0100
Subject: [PATCH] Dump only those tables that planetdump needs

Closes #856.
---
 cookbooks/db/templates/default/backup-db.erb | 17 ++++++++++++++++-
 1 file changed, 16 insertions(+), 1 deletion(-)

diff --git a/cookbooks/db/templates/default/backup-db.erb b/cookbooks/db/templates/default/backup-db.erb
index a9a0c8005..4e5fb29ab 100644
--- a/cookbooks/db/templates/default/backup-db.erb
+++ b/cookbooks/db/templates/default/backup-db.erb
@@ -5,6 +5,21 @@
 D=`date +%Y-%m-%d`
 F=/store/backup/osm-${D}.dmp
 
-pg_dump --user=backup --format=custom --file=$F openstreetmap && \
+pg_dump --user=backup \
+        --format=custom \
+        --data-only \
+        --table=users \
+        --table=changesets \
+        --table=changeset_tags \
+        --table=changeset_comments \
+        --table=nodes \
+        --table=node_tags \
+        --table=relations \
+        --table=relation_tags \
+        --table=relation_members \
+        --table=ways \
+        --table=way_tags \
+        --table=way_nodes \
+        --file=$F openstreetmap && \
   rsync --preallocate $F backup.openstreetmap.org::backup && \
   rm -f $F
-- 
2.47.3