From: Tom Hughes Date: Wed, 11 Oct 2017 17:53:25 +0000 (+0100) Subject: Switch postgres replication to use WAL-E X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain/a26a8b173f903cf338c1749a4238c3710c17726c?hp=337b0ec13142af6885c56b96c985508d3b1ae832 Switch postgres replication to use WAL-E --- diff --git a/roles/db-master.rb b/roles/db-master.rb index eaaca0a49..e29b7131c 100644 --- a/roles/db-master.rb +++ b/roles/db-master.rb @@ -8,7 +8,7 @@ default_attributes( :defaults => { :wal_level => "hot_standby", :archive_mode => "on", - :archive_command => "/bin/cp %p /store/postgresql/archive/%f", + :archive_command => "/usr/local/bin/openstreetmap-wal-e --terse wal-push %p", :max_wal_senders => "3", :late_authentication_rules => [ { :database => "replication", :user => "replication", :address => "146.179.159.168/32" }, diff --git a/roles/db-slave.rb b/roles/db-slave.rb index 03b6fd89b..3f7fa44f2 100644 --- a/roles/db-slave.rb +++ b/roles/db-slave.rb @@ -15,7 +15,7 @@ default_attributes( :user => "replication", :passwords => { :bag => "db", :item => "passwords" } }, - :restore_command => "/usr/bin/rsync karm.ic.openstreetmap.org::archive/%f %p" + :restore_command => "/usr/local/bin/openstreetmap-wal-e --terse wal-fetch %f %p" } } }