]> git.openstreetmap.org Git - chef.git/blobdiff - cookbooks/nominatim/templates/default/vacuum-db-nominatim.erb
nominatim: rotate apache logs more often
[chef.git] / cookbooks / nominatim / templates / default / vacuum-db-nominatim.erb
index 77b1257ef2016f09c72a1169a6d1ed8e4adea3c1..dacdbf631411938312a2f5e55f06ecd935424cb7 100644 (file)
@@ -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