X-Git-Url: https://git.openstreetmap.org/chef.git/blobdiff_plain/a4e98a39669d82fc53a3d7f3fcc65689c05cc6cd..55541f7cbea84613a5278eaf4165302f1e70b321:/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb diff --git a/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb b/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb index 77b1257ef..dacdbf631 100644 --- a/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb +++ b/cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb @@ -5,10 +5,10 @@ # Vaccum all tables with indices on integer arrays. # Agressive vacuuming seems to help against index bloat. -psql -q -d nominatim -c 'VACUUM ANALYSE search_name' -psql -q -d nominatim -c 'VACUUM ANALYSE search_name_country' +psql -q -d <%= @db %> -c 'VACUUM ANALYSE search_name' +psql -q -d <%= @db %> -c 'VACUUM ANALYSE search_name_country' for i in `seq 0 246`; do - psql -q -d nominatim -c "VACUUM ANALYSE search_name_${i}" + psql -q -d <%= @db %> -c "VACUUM ANALYSE search_name_${i}" done