From b91d969554e6c2cdad2348dbe47f050ecca2ee4a Mon Sep 17 00:00:00 2001
From: Don Armstrong <don@donarmstrong.com>
Date: Sat, 25 Jul 2020 21:18:46 -0700
Subject: [PATCH] add code to dump the database

---
 examples/debian/misc/db_dump.sh | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100755 examples/debian/misc/db_dump.sh

diff --git a/examples/debian/misc/db_dump.sh b/examples/debian/misc/db_dump.sh
new file mode 100755
index 0000000..ee9e686
--- /dev/null
+++ b/examples/debian/misc/db_dump.sh
@@ -0,0 +1,21 @@
+#!/bin/sh
+
+set -e
+
+cd /srv/bugs.debian.org/www/db_dump;
+
+DUMP_TIME=$(date +%Y%m%d_%H%M)
+
+# We should be run at the lowest priority
+ionice -c 3 -p $$ > /dev/null 2>&1
+renice -n 19 -p $$ > /dev/null 2>&1
+
+pg_dump --data-only --disable-triggers service=debbugs 2>/dev/null | \
+    gzip -c > debbugs_dump_${DUMP_TIME}.gz
+
+ln -sf debbugs_dump_${DUMP_TIME}.gz debbugs_dump_current.gz
+
+# delete any dumps older than 4 days
+find . -maxdepth 1 -mindepth 1 -type f -iname 'debbugs_dump_*.gz' \
+     -ctime +4 -delete
+
-- 
2.39.2