From 7471caa12144cbc7b41c2056b1aed1f0fbcb6a13 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 8 Aug 2013 19:29:37 +0200 Subject: [PATCH] backup for nominatim --- cookbooks/nominatim/recipes/default.rb | 16 ++++++++++++++++ .../templates/default/backup-nominatim.erb | 19 +++++++++++++++++++ 2 files changed, 35 insertions(+) create mode 100644 cookbooks/nominatim/templates/default/backup-nominatim.erb diff --git a/cookbooks/nominatim/recipes/default.rb b/cookbooks/nominatim/recipes/default.rb index 845bb7700..cd12156d8 100644 --- a/cookbooks/nominatim/recipes/default.rb +++ b/cookbooks/nominatim/recipes/default.rb @@ -243,3 +243,19 @@ end 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 diff --git a/cookbooks/nominatim/templates/default/backup-nominatim.erb b/cookbooks/nominatim/templates/default/backup-nominatim.erb new file mode 100644 index 000000000..03dc01f46 --- /dev/null +++ b/cookbooks/nominatim/templates/default/backup-nominatim.erb @@ -0,0 +1,19 @@ +#!/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 -- 2.43.2