[dak/master] db

[Joerg Jaspert <joerg@debian.org>]

also export roles.
daily dump the dak-dev projectb and recreate it from the postdump.
also sync the global stuff from dak to dakdev.

Signed-off-by: Joerg Jaspert <joerg@debian.org>
---
 config/debian/cron.dinstall |   25 ++++++++++++++++++++++---
 1 files changed, 22 insertions(+), 3 deletions(-)

diff --git a/config/debian/cron.dinstall b/config/debian/cron.dinstall
index 383ba33..708f49b 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
@@ -664,6 +675,14 @@ GO=(
 stage $GO
 
 GO=(
+	FUNC="pgdakdev"
+	TIME="dak-dev db"
+	ARGS=""
+	ERR="false"
+)
+stage $GO
+
+GO=(
     FUNC="expire"
     TIME="expire_dumps"
     ARGS=""
-- 
1.5.6.5