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	dpavlin	1.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"