X-Git-Url: https://dev.renevier.net/?p=syj.git;a=blobdiff_plain;f=scripts%2Fupdategeoip.sh;h=1626bb3d65e75b8b103c0e13cd2d889438615732;hp=eb9327e23a22d1d9a8b72abf11f37c2af4baa233;hb=03f49f88786c9eefcb850927958646266f11a86d;hpb=d46d626700669a4c9a1e9ffc407fa89e6d6c7e21

diff --git a/scripts/updategeoip.sh b/scripts/updategeoip.sh
index eb9327e..1626bb3 100755
--- a/scripts/updategeoip.sh
+++ b/scripts/updategeoip.sh
@@ -81,3 +81,4 @@ unzip ${GEOIPDB##*/} $GEOIPCVS
 
 # insert all values from csv to database
 sed -e 's/"\([^"]\+\)","\([^"]\+\)","\([^"]\+\)","\([^"]\+\)","\([^"]\+\)","\([^"]\+\)"/INSERT INTO geoip (begin_ip, end_ip, country) VALUES ('\''\3'\'','\''\4'\'','\''\5'\'');/' $GEOIPCVS | psql --set "ON_ERROR_STOP=1" -f -
+psql --set "ON_ERROR_STOP=1" -c "VACUUM ANALYZE geoip;"