1 |
|
2 |
db=PlivaHealth |
3 |
prod=health.pliva.hr |
4 |
dir=/data/health_html |
5 |
|
6 |
all: |
7 |
@echo dump,create,drop,insert,fill |
8 |
|
9 |
dump: |
10 |
pg_dump -s $(db) > $(db)-shema.sql |
11 |
pg_dump -a -d $(db) > $(db)-data.sql |
12 |
|
13 |
dumpall: |
14 |
pg_dump $(db) > $(db).sql |
15 |
|
16 |
create: |
17 |
createdb $(db) |
18 |
drop: |
19 |
psql template1 -c "drop database $(db)" |
20 |
|
21 |
insert: |
22 |
psql $(db) < $(db)-data.sql |
23 |
|
24 |
shema: |
25 |
psql $(db) < $(db)-shema.sql |
26 |
|
27 |
fill: drop create shema insert |
28 |
|
29 |
dist: |
30 |
rsync -a -e "ssh -q" $(dir) $(prod):$(dir) |
31 |
|
32 |
dist-pg: |
33 |
pg_dump --no-reconnect $(db) > $(db).sql |
34 |
scp $(db).sql $(prod):$(dir) |
35 |
ssh $(prod) "createdb $(db) && psql $(db) < $(dir)/$(db).sql" |