]> git.donarmstrong.com Git - wannabuild.git/blobdiff - trigger.daily
Add space so that the sql statement looks nicer.
[wannabuild.git] / trigger.daily
index 184bd681b5507fb28aa0c7d9be73a4956b89ba3a..0926de133362ae03a5b6b56624dc1c57f8160ba0 100755 (executable)
@@ -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,9 @@ 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
+
+(cd /org/wanna-build/dumps && /org/wanna-build/expire_dumps -d . -f "dump_*")
 
 #
 # Only update stats if it's been at least 20h since the last time.