From a5afb29c460ffe42f50daa8481a4a4fdeb778026 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Sun, 12 Mar 2017 11:32:52 +0000 Subject: [PATCH] Update database servers to postgres 9.5 --- roles/db-master.rb | 2 +- roles/db-slave.rb | 2 +- roles/db.rb | 2 +- roles/karm.rb | 5 ++--- roles/katla.rb | 2 +- roles/ramoth.rb | 2 +- 6 files changed, 7 insertions(+), 8 deletions(-) diff --git a/roles/db-master.rb b/roles/db-master.rb index 78de0b69f..ae33b625c 100644 --- a/roles/db-master.rb +++ b/roles/db-master.rb @@ -3,7 +3,7 @@ description "Role applied to all the master database server" default_attributes( :postgresql => { - :versions => ["9.1"], + :versions => ["9.5"], :settings => { :defaults => { :wal_level => "hot_standby", diff --git a/roles/db-slave.rb b/roles/db-slave.rb index dbcfc2095..03b6fd89b 100644 --- a/roles/db-slave.rb +++ b/roles/db-slave.rb @@ -3,7 +3,7 @@ description "Role applied to all slave database servers" default_attributes( :postgresql => { - :versions => ["9.1"], + :versions => ["9.5"], :settings => { :defaults => { :hot_standby => "on", diff --git a/roles/db.rb b/roles/db.rb index c8aebed0d..f3c324422 100644 --- a/roles/db.rb +++ b/roles/db.rb @@ -39,7 +39,7 @@ default_attributes( "/store/rails" => { :host => "ironbelly", :path => "/store/rails" } }, :postgresql => { - :versions => ["9.1"], + :versions => ["9.5"], :settings => { :defaults => { :listen_addresses => "*", diff --git a/roles/karm.rb b/roles/karm.rb index 21a497a67..a64b3337d 100644 --- a/roles/karm.rb +++ b/roles/karm.rb @@ -6,7 +6,7 @@ default_attributes( :sources => ["postgresql"] }, :db => { - :cluster => "9.1/main" + :cluster => "9.5/main" }, :networking => { :interfaces => { @@ -28,8 +28,7 @@ default_attributes( :effective_cache_size => "180GB", :effective_io_concurrency => "256" } - }, - :versions => ["9.1"] + } }, :sysctl => { :postgres => { diff --git a/roles/katla.rb b/roles/katla.rb index 8144942cf..399c767b2 100644 --- a/roles/katla.rb +++ b/roles/katla.rb @@ -6,7 +6,7 @@ default_attributes( :sources => ["postgresql"] }, :db => { - :cluster => "9.1/main" + :cluster => "9.5/main" }, :devices => { :store_slow => { diff --git a/roles/ramoth.rb b/roles/ramoth.rb index 900714597..fad21355a 100644 --- a/roles/ramoth.rb +++ b/roles/ramoth.rb @@ -6,7 +6,7 @@ default_attributes( :sources => ["postgresql"] }, :db => { - :cluster => "9.1/main" + :cluster => "9.5/main" }, :devices => { :store_openstreetmap => { -- 2.43.2