calebasse / reinit-psql.sh @ ff25533d
| 1 | 3fb150de | Jérôme Schneider | #!/bin/bash
|
|---|---|---|---|
| 2 | |||
| 3 | DUMP='calebasse-dump-'$(date +%Y%m%d%H%M)'.sql.bz2' |
||
| 4 | |||
| 5 | sudo -u postgres dropdb calebasse |
||
| 6 | sudo -u postgres createdb calebasse -O $USER |
||
| 7 | |||
| 8 | if [ $1 == 'dl' ]; then |
||
| 9 | ssh calebasse.aps42.entrouvert.com ssh prod "sudo -u postgres pg_dump -O calebasse | bzip2 > $DUMP" |
||
| 10 | scp calebasse.aps42.entrouvert.com:$DUMP . |
||
| 11 | ssh calebasse.aps42.entrouvert.com "rm $DUMP" |
||
| 12 | fi
|
||
| 13 | |||
| 14 | mv $DUMP last_dump.sql.bz2 |
||
| 15 | |||
| 16 | bzip2 -dc ./last_dump.sql.bz2 | psql calebasse
|