Add max_wal_size support for postgresql 9.5

[chef.git] / roles / tile.rb

diff --git a/roles/tile.rb b/roles/tile.rb
index 5abf673e38637a61cb16e2e5c6ee50e93ab47e42..433805febaa6b8b0d61516b564b70aff913ea551 100644 (file)
--- a/roles/tile.rb
+++ b/roles/tile.rb
@@ -6,27 +6,23 @@ default_attributes(
     :users => {
       :tile => {
         :status => :role,
     :users => {
       :tile => {
         :status => :role,

-        :members => [ :jburgess, :tomh ]
-      },
-    },
+        :members => [:jburgess, :tomh]
+      }
+    }

   },
   :apache => {
   },
   :apache => {

-    :mpm => "worker",
+    :mpm => "event",

     :timeout => 60,
     :timeout => 60,

-    :worker => {
-      :server_limit => 48,
+    :event => {
+      :server_limit => 60,

       :max_clients => 1200,
       :max_clients => 1200,

-      :threads_per_child => 25,
+      :threads_per_child => 20,

       :min_spare_threads => 30,
       :max_spare_threads => 180,
       :max_requests_per_child => 100000
     }
   },
       :min_spare_threads => 30,
       :max_spare_threads => 180,
       :max_requests_per_child => 100000
     }
   },

-  :apt => {
-    :sources => [ "ubuntugis-stable" ]
-  },

   :postgresql => {
   :postgresql => {

-    :versions => [ "9.1" ],

     :settings => {
       :defaults => {
         :temp_buffers => "32MB",
     :settings => {
       :defaults => {
         :temp_buffers => "32MB",


@@ -34,7 +30,8 @@ default_attributes(
         :wal_buffers => "1024kB",
         :wal_writer_delay => "500ms",
         :commit_delay => "10000",
         :wal_buffers => "1024kB",
         :wal_writer_delay => "500ms",
         :commit_delay => "10000",

-        :checkpoint_segments => "60"
+        :checkpoint_segments => "60",
+        :max_wal_size => "2880MB"

       }
     }
   },
       }
     }
   },


@@ -44,39 +41,45 @@ default_attributes(
       :parameters => {
         "net.core.somaxconn" => 10000
       }
       :parameters => {
         "net.core.somaxconn" => 10000
       }

+    },
+    :kernel_scheduler_tune => {
+      :comment => "Tune kernel scheduler preempt",
+      :parameters => {
+        "kernel.sched_min_granularity_ns" => 10000000,
+        "kernel.sched_wakeup_granularity_ns" => 15000000
+      }

     }
   },
   :tile => {
     }
   },
   :tile => {

-    :database => {
-      :cluster => "9.1/main"
-    },

     :data => {
       :world_boundaries => {
         :url => "http://planet.openstreetmap.org/historical-shapefiles/world_boundaries-spherical.tgz"
       },
     :data => {
       :world_boundaries => {
         :url => "http://planet.openstreetmap.org/historical-shapefiles/world_boundaries-spherical.tgz"
       },

-      :shoreline => {
-        :url => "http://planet.openstreetmap.org/historical-shapefiles/shoreline_300.tar.bz2",
-        :directory => "shoreline_300"
+      :simplified_land_polygons => {
+        :url => "http://data.openstreetmapdata.com/simplified-land-polygons-complete-3857.zip",
+        :refresh => true

       },
       :admin_boundaries => {
         :url => "http://www.naturalearthdata.com/http//www.naturalearthdata.com/download/110m/cultural/ne_110m_admin_0_boundary_lines_land.zip",
         :directory => "ne_110m_admin_0_boundary_lines_land"
       },
       },
       :admin_boundaries => {
         :url => "http://www.naturalearthdata.com/http//www.naturalearthdata.com/download/110m/cultural/ne_110m_admin_0_boundary_lines_land.zip",
         :directory => "ne_110m_admin_0_boundary_lines_land"
       },

-      :populated_places => {
-        :url => "http://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/cultural/ne_10m_populated_places.zip",
-        :directory => "ne_10m_populated_places",
-        :original => "ne_10m_populated_places.shp",
-        :processed => "ne_10m_populated_places_fixed.shp"
+      :land_polygons => {
+        :url => "http://data.openstreetmapdata.com/land-polygons-split-3857.zip",
+        :refresh => true
+      },
+      :antarctica_icesheet_polygons => {
+        :url => "http://data.openstreetmapdata.com/antarctica-icesheet-polygons-3857.zip",
+        :refresh => true

       },
       },

-      :processed => {
-        :url => "http://planet.openstreetmap.org/historical-shapefiles/processed_p.tar.bz2",
-        :directory => "processed_p"
+      :antarctica_icesheet_outlines => {
+        :url => "http://data.openstreetmapdata.com/antarctica-icesheet-outlines-3857.zip",
+        :refresh => true

       }
     },
     :styles => {
       :default => {
         :repository => "git://github.com/gravitystorm/openstreetmap-carto.git",
       }
     },
     :styles => {
       :default => {
         :repository => "git://github.com/gravitystorm/openstreetmap-carto.git",

-        :revision => "v2.2.0",
+        :revision => "v2.42.0",

         :max_zoom => 19
       }
     }
         :max_zoom => 19
       }
     }