Dump the whole database, including the roles.

diff --git a/trigger.daily b/trigger.daily
index 184bd681b5507fb28aa0c7d9be73a4956b89ba3a..6cf74228e61b8909bccfa9ec661dc9cedb4f32cc 100755 (executable)
--- 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.