calebasse / Makefile @ 8e6a3c86
| 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 |