X-Git-Url: https://dev.renevier.net/?a=blobdiff_plain;f=scripts%2Fupdategeonames.sh;h=e6ce263136f4ed06499296d7d2a1cab2d184a05e;hb=9714df1a97fe9f6c53a52ea0aaf3fcc090124992;hp=ff5c8cdfa1059d1f84cc17a4059a8ed30a092d54;hpb=190fd621df4920c56a422c03663874cddaa67d64;p=syj.git

diff --git a/scripts/updategeonames.sh b/scripts/updategeonames.sh
index ff5c8cd..e6ce263 100755
--- a/scripts/updategeonames.sh
+++ b/scripts/updategeonames.sh
@@ -3,8 +3,7 @@ set -e
 
 GEONAMESXML=http://ws.geonames.org/countryInfo
 
-EXECDIR=$PWD/${0%/*}
-. $EXECDIR/db_auth.sh
+. ${0%/*}/db_auth.sh
 
 usage() {
     echo Usage: ${0##*/} [options]
@@ -72,4 +71,5 @@ for line in $(cat ${GEONAMESXML##*/}); do
 done
 echo "INSERT INTO geonames (country, minlon, minlat, maxlon, maxlat) VALUES ('EU', -26, 34, 40, 68);" >> $TMPFILE
 echo "INSERT INTO geonames (country, minlon, minlat, maxlon, maxlat) VALUES ('AP', 90, -20, -140, 68);" >> $TMPFILE
+echo "VACUUM ANALYZE geonames;" >> $TMPFILE
 psql --set "ON_ERROR_STOP=1" -f $TMPFILE