Project

General

Profile

1 6522 aaronmk
selfDir_NzrNZp := $(dir $(lastword $(MAKEFILE_LIST)))
2
root := $(selfDir_NzrNZp)..
3
include $(root)/lib/common.Makefile
4 3699 aaronmk
5
6 3393 aaronmk
##### Vars/functions
7
8 3403 aaronmk
# Make
9
SHELL := /bin/bash
10
11 3438 aaronmk
# OS
12
os := $(shell uname)
13
isMac := $(filter Darwin,$(os))
14 3393 aaronmk
15 3438 aaronmk
# System
16
dateFmt := %Y-%m-%d-%H-%M-%S
17
mtime = $(shell $(if $(isMac),stat -f %Sm -t "$(dateFmt)" $(1),date\
18
--reference=$(1) +"$(dateFmt)"))
19
20 3393 aaronmk
# Terminal
21
esc := '['
22
reset := $(esc)'0m'
23
emph := $(esc)'7m '
24
endEmph := ' '$(reset)
25
26
# User interaction
27
28
confirm = $(if $(shell read -p $(emph)"$(1)"$(endEmph)$$'$(if\
29
$(2),\n$(2))\nContinue? (y/n) ' REPLY; test "$$REPLY" = y && echo t),,\
30
$(error Aborting))
31
32 3438 aaronmk
# Paths
33 6522 aaronmk
bin := $(root)/bin
34 3438 aaronmk
35 3393 aaronmk
# DB
36
psqlVerbose := $(bin)/psql_script_vegbien --echo-all
37
pg_dump := $(bin)/pg_dump_vegbien
38 3404 aaronmk
backup := "time" env data=1 $(pg_dump)
39
restore := "time" $(bin)/postgres_vegbien pg_restore --exit-on-error
40
restoreBien := $(restore) --dbname=vegbien
41
# pg_restore doesn't support PGDATABASE env var
42 3393 aaronmk
rmSchema = 'DROP SCHEMA IF EXISTS "$(1)" CASCADE;'
43
44 3437 aaronmk
##### Backups
45 3393 aaronmk
46 6526 aaronmk
backups := $(wildcard *.backup)
47
48
md5s: _always $(backups:%=%.md5) ;
49
50 3395 aaronmk
# Must come before %.sql with no prerequisites to be matched first
51 6520 aaronmk
%.md5: %
52 6536 aaronmk
	nice -n +5 md5sum $<|cut -d ' ' -f 1 >$@
53 6520 aaronmk
54
# Must come before %.sql with no prerequisites to be matched first
55 3395 aaronmk
%.sql: %
56 3399 aaronmk
	$(restore) $< >$@
57 3395 aaronmk
58 4751 aaronmk
# Full DB
59
# Must come before %.backup to be matched first
60
vegbien.%.backup:
61
	$(backup) all >$@
62
63 3544 aaronmk
backup* = $(backup) $* >$@
64
65 3393 aaronmk
# Note: This can't be used for the current (unrotated) public schema because
66
# pg_dump doesn't back up the CREATE SCHEMA statement for it, assuming falsely
67
# that public already exists because it's in template1.
68 3543 aaronmk
%.backup:
69
	$(backup*)
70 6521 aaronmk
	$(MAKE) $@.md5
71 3544 aaronmk
72
# When testing, turn off %.sql so make won't skip `%.sql: %` in favor of it
73
ifeq ($(filter %.backup/test,$(MAKECMDGOALS)),)
74 3543 aaronmk
%.sql:
75
	env plain=1 $(backup*)
76 3544 aaronmk
endif
77 3393 aaronmk
78 3402 aaronmk
%.backup/restore: %.backup _always
79 3399 aaronmk
	$(restoreBien) $<
80 3393 aaronmk
81 3402 aaronmk
%.sql/restore: %.sql _always
82
	$(bin)/psql_script_vegbien <$<
83
# pg_restore only supports "non-plain-text formats"
84
# (http://www.postgresql.org/docs/9.1/static/app-pgrestore.html)
85
86 3409 aaronmk
%.backup/test: %.backup.sql _always
87
	rm $<
88
89 3438 aaronmk
%.backup/rotate: %.backup _always
90
	mv $< $*.$(call mtime,$<).backup
91
92 3437 aaronmk
#### Archived imports
93 3393 aaronmk
94
confirmRm = $(call confirm,WARNING: This will delete the archived import $(1)!)
95
96
%.backup/remove: %.backup _always
97
	@$(call confirmRm,$*)
98
	echo $(call rmSchema,$*)|$(bin)/psql_script_vegbien
99
100
%.backup/rm_indexes: %.backup _always
101
	$(pg_dump) $*|$(bin)/mk_rm_indexes|$(psqlVerbose)
102 3407 aaronmk
103 3701 aaronmk
##### Synchronization
104
105 6469 aaronmk
rsyncBackups := $(rsync) --include="/*.backup" --include="/*.sql"\
106
--include="/*.csv" --exclude="**"
107 3701 aaronmk
108
upload: _always
109
	$(rsyncBackups) $(local) $(remote)
110
download: _always
111
	$(rsyncBackups) $(remote) $(local)