calebasse / Makefile @ 017f4158
1 |
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 |
|
19 |
reload: |
20 |
dropdb calebasse |
21 |
createdb calebasse |
22 |
bzip2 -dc ./$(LAST_DUMP) | psql calebasse |