From: Sarah Hoffmann Date: Sun, 6 Dec 2020 15:47:01 +0000 (+0100) Subject: dulcy: switch to postgres 13 and prepare for import X-Git-Url: https://git.openstreetmap.org/chef.git/commitdiff_plain/e16fbe6ab0744f178098d51cbc8976bf7067c2ea dulcy: switch to postgres 13 and prepare for import --- diff --git a/roles/dulcy.rb b/roles/dulcy.rb index f10868020..619dc6860 100644 --- a/roles/dulcy.rb +++ b/roles/dulcy.rb @@ -28,25 +28,25 @@ default_attributes( } }, :postgresql => { - :versions => ["12"], + :versions => ["13"], :settings => { :defaults => { :work_mem => "300MB", :maintenance_work_mem => "10GB", :random_page_cost => "1.5", :effective_cache_size => "60GB", - :fsync => "on", + :fsync => "off", :effective_io_concurrency => "500" } } }, :nominatim => { - :state => "standalone", + :state => "off", :enable_backup => false, :enable_git_updates => true, :dbadmins => %w[lonvia tomh], - :dbcluster => "12/main", - :postgis => "2.5", + :dbcluster => "13/main", + :postgis => "3", :flatnode_file => "/ssd/nominatim/nodes.store", :logdir => "/ssd/nominatim/log", :tablespaces => {