health_html/.data/Makefile


db=PlivaHealth
prod=health.pliva.hr
dir=/data/health_html

all:
        @echo dump,create,drop,insert,fill

dump:
        pg_dump -s $(db) > $(db)-shema.sql
        pg_dump -a -d $(db) > $(db)-data.sql

dumpall:
        pg_dump $(db) > $(db).sql

create:
        createdb $(db)
drop:
        psql template1 -c "drop database $(db)"

insert:
        psql $(db) < $(db)-data.sql

shema:
        psql $(db) < $(db)-shema.sql

fill: drop create shema insert

dist:
        rsync -a -e "ssh -q" $(dir) $(prod):$(dir)

dist-pg:
        pg_dump --no-reconnect $(db) > $(db).sql
        scp $(db).sql $(prod):$(dir)
        ssh $(prod) "createdb $(db) && psql $(db) < $(dir)/$(db).sql"
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"