calebasse/reinit-psql.sh @ 9433e992
| 3fb150de | Jérôme Schneider | #!/bin/bash
|
|
| 2a56d9e8 | Jérôme Schneider | DUMP='last_dump.sql.bz2'
|
|
HELP="./`basename $0` [new|dl]"
|
|||
if [ $# -gt 1 ]; then
|
|||
echo $HELP
|
|||
exit 1
|
|||
fi
|
|||
if [ $# ]; then
|
|||
if [ "$1" != "new" -a "$1" != "dl" ]; then
|
|||
echo $HELP
|
|||
exit 1
|
|||
fi
|
|||
fi
|
|||
| 3fb150de | Jérôme Schneider | ||
sudo -u postgres dropdb calebasse
|
|||
sudo -u postgres createdb calebasse -O $USER
|
|||
| 2a56d9e8 | Jérôme Schneider | if [ $# ]; then
|
|
if [ $1 = "new" ]; then
|
|||
ssh calebasse.aps42.entrouvert.com ssh prod "/etc/cron.daily/calebasse_dumpdb"
|
|||
fi
|
|||
ssh calebasse.aps42.entrouvert.com scp prod:/tmp/$DUMP .
|
|||
| 3fb150de | Jérôme Schneider | scp calebasse.aps42.entrouvert.com:$DUMP .
|
|
| 2a56d9e8 | Jérôme Schneider | ssh calebasse.aps42.entrouvert.com "rm /tmp/$DUMP"
|
|
| 3fb150de | Jérôme Schneider | fi
|
|
bzip2 -dc ./last_dump.sql.bz2 | psql calebasse
|