From: Don Armstrong <don@donarmstrong.com>
Date: Sun, 26 Jul 2020 04:18:46 +0000 (-0700)
Subject: add code to dump the database
X-Git-Url: https://git.donarmstrong.com/?p=debbugs.git;a=commitdiff_plain;h=b91d969554e6c2cdad2348dbe47f050ecca2ee4a

add code to dump the database
---

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
+