Project

General

Profile

Download (436 Bytes) Statistics
| Branch: | Tag: | Revision:
28c50c88 Benjamin Dauvergne
all:
@true

DATE=$(shell date +%Y%m%d%H%M)

DUMP=calebasse-dump-$(DATE).sql.bz2
LAST_DUMP=calebasse-dump-last.sql.bz2

dump:
pg_dump -O -c | bzip2 >$(HOME)/$(DUMP)
ln -sf $(HOME)/$(DUMP) $(HOME)/$(LAST_DUMP)

load:
dropdb calebasse
createdb calebasse
scp aps-prod:/home/calebasse/$(LAST_DUMP) .
bzip2 -dc ./$(LAST_DUMP) | psql calebasse
75367829 Benjamin Dauvergne
reload:
dropdb calebasse
createdb calebasse
bzip2 -dc ./$(LAST_DUMP) | psql calebasse