Project

General

Profile

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