Dump the pgsql database before and after the "daily" trigger.

[wannabuild.git] / trigger.daily

diff --git a/trigger.daily b/trigger.daily
index 1ee7824dd44ba487915e26d93d1cbab5fad5a4cc..184bd681b5507fb28aa0c7d9be73a4956b89ba3a 100755 (executable)
--- a/trigger.daily
+++ b/trigger.daily
@@ -38,6 +38,9 @@ cleanup() {
 }
 trap cleanup 0
 
+echo Dumping wanna-build databases...
+pg_dump service=wanna-build-privileged | bzip2 > /org/wanna-build/dumps/dump_pre_$(date +%Y.%m.%d-%H:%M:%S).bz2
+
 echo Updating wanna-build databases...
 umask 027
 
@@ -216,6 +219,9 @@ for d in $DISTS; do
 done
 
 echo "merge ended: `date`"
+
+pg_dump service=wanna-build-privileged | bzip2 > /org/wanna-build/dumps/dump_post_$(date +%Y.%m.%d-%H:%M:%S).bz2
+
 #
 # Only update stats if it's been at least 20h since the last time.
 #