X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=config%2Fdebian%2Fcron.dinstall;h=708f49bb9c206506652ffe5e5ed9d380eae04dd8;hb=e8886b409b2824c6dfd2eb806c3a2f59c335642b;hp=383ba3346aaa4f3a32dec93b8c7270a6eded8a17;hpb=1c29cf2b20f05eceb1d6355363cf4963469394c0;p=dak.git diff --git a/config/debian/cron.dinstall b/config/debian/cron.dinstall index 383ba334..708f49bb 100755 --- a/config/debian/cron.dinstall +++ b/config/debian/cron.dinstall @@ -74,9 +74,20 @@ function pgdump_pre() { function pgdump_post() { log "Creating post-daily-cron-job backup of projectb database..." cd $base/backup - POSTDUMP=$base/backup/dump_$(date +%Y.%m.%d-%H:%M:%S) - pg_dump projectb > $POSTDUMP - ln -sf $POSTDUMP current + POSTDUMP=$(date +%Y.%m.%d-%H:%M:%S) + pg_dump projectb > $base/backup/dump_$POSTDUMP + pg_dumpall --globals-only > $base/backup/dumpall_$POSTDUMP + ln -sf $base/backup/dump_$POSTDUMP current + ln -sf $base/backup/dumpall_$POSTDUMP currentall +} + +# Load the dak-dev projectb +function pgdakdev() { + cd $base/backup + echo "drop database projectb" | psql -p 5433 template1 + cat currentall | psql -p 5433 template1 + createdb -p 5433 -T template0 projectb + fgrep -v '\connect' `cat current` | psql -p 5433 projectb } # Updating various files @@ -663,6 +674,14 @@ GO=( ) stage $GO +GO=( + FUNC="pgdakdev" + TIME="dak-dev db" + ARGS="" + ERR="false" +) +stage $GO + GO=( FUNC="expire" TIME="expire_dumps"