cd $base/backup
POSTDUMP=$(date +%Y.%m.%d-%H:%M:%S)
pg_dump projectb > $base/backup/dump_$POSTDUMP
- pg_dumpall --globals-only > $base/backup/dumpall_$POSTDUMP
+ #pg_dumpall --globals-only > $base/backup/dumpall_$POSTDUMP
ln -sf $base/backup/dump_$POSTDUMP current
- ln -sf $base/backup/dumpall_$POSTDUMP currentall
+ #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
+ #cat currentall | psql -p 5433 template1
+ createdb -p 5433 -T template1 projectb
fgrep -v '\connect' current | psql -p 5433 projectb
}