munin_plugin "nominatim_throttled_ips" do
target "#{source_directory}/munin/nominatim_throttled_ips"
end
+
+template "/usr/local/bin/backup-nominatim" do
+ source "backup-nominatim.erb"
+ owner "root"
+ group "root"
+ mode 0755
+end
+
+cron "nominatim_backup" do
+ hour "3"
+ minute "00"
+ day "1"
+ command "/usr/local/bin/backup-nominatim"
+ user "nominatim"
+ mailto email_errors
+end
--- /dev/null
+#!/bin/sh
+
+# DO NOT EDIT - This file is being maintained by Chef
+
+# Partial read-only backup only, to restore:
+#
+# ./utils/setup.php --create-db --setup-db --create-functions --create-partition-functions
+# pg_restore --no-tablespaces -O -d nominatim $F
+# ./utils/setup.php --create-functions --create-partition-functions
+
+
+D=`date +%Y-%m-%d`
+F=/tmp/nominatim-${D}.dmp
+
+pg_dump --file=$F -F c -Z 9 -t 'country' -t file -t '*columns' -t 'import_polygon_*' -t import_status -t place_addressline -t placex -t search_name -t 'seq_*' -t word -t gb_postcode <%= node[:nominatim][:database][:dbname] %>
+
+rsync $F backup.openstreetmap.org::backup
+
+rm -f $F