| 1 |
28c50c88
|
Benjamin Dauvergne
|
all:
|
| 2 |
|
|
@true
|
| 3 |
|
|
|
| 4 |
|
|
DATE=$(shell date +%Y%m%d%H%M)
|
| 5 |
|
|
|
| 6 |
|
|
DUMP=calebasse-dump-$(DATE).sql.bz2
|
| 7 |
|
|
LAST_DUMP=calebasse-dump-last.sql.bz2
|
| 8 |
|
|
|
| 9 |
|
|
dump:
|
| 10 |
|
|
pg_dump -O -c | bzip2 >$(HOME)/$(DUMP)
|
| 11 |
|
|
ln -sf $(HOME)/$(DUMP) $(HOME)/$(LAST_DUMP)
|
| 12 |
|
|
|
| 13 |
|
|
load:
|
| 14 |
|
|
dropdb calebasse
|
| 15 |
|
|
createdb calebasse
|
| 16 |
|
|
scp aps-prod:/home/calebasse/$(LAST_DUMP) .
|
| 17 |
|
|
bzip2 -dc ./$(LAST_DUMP) | psql calebasse
|
| 18 |
75367829
|
Benjamin Dauvergne
|
|
| 19 |
|
|
reload:
|
| 20 |
|
|
dropdb calebasse
|
| 21 |
|
|
createdb calebasse
|
| 22 |
|
|
bzip2 -dc ./$(LAST_DUMP) | psql calebasse
|