From: Kurt Roeckx <kurt@roeckx.be>
Date: Sat, 12 Dec 2009 21:48:46 +0000 (+0000)
Subject: Dump the whole database, including the roles.
X-Git-Url: https://git.donarmstrong.com/?p=wannabuild.git;a=commitdiff_plain;h=e6e72d524932a8ec021123236e68640ecd87b6ac

Dump the whole database, including the roles.
---

diff --git a/trigger.daily b/trigger.daily
index 184bd68..6cf7422 100755
--- a/trigger.daily
+++ b/trigger.daily
@@ -39,7 +39,7 @@ 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
+sudo -u postgres /usr/bin/pg_dumpall --cluster 8.4/wanna-build | bzip2 > /org/wanna-build/dumps/dump_pre_$(date +%Y.%m.%d-%H:%M:%S).bz2
 
 echo Updating wanna-build databases...
 umask 027
@@ -220,7 +220,7 @@ 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
+sudo -u postgres /usr/bin/pg_dumpall --cluster 8.4/wanna-build | 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.