From: Sarah Hoffmann Date: Thu, 26 Apr 2012 22:05:55 +0000 (+0200) Subject: timezone trouble X-Git-Tag: deploy~700 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/129c66a34542b76fe6784143e4029c51e09153b9?ds=sidebyside;hp=a9bcf2ae61ee5cb23e007e254cc4ad2899947e08 timezone trouble --- diff --git a/munin/nominatim_importlag b/munin/nominatim_importlag index 8d69f3ce..657938db 100755 --- a/munin/nominatim_importlag +++ b/munin/nominatim_importlag @@ -21,7 +21,7 @@ if [ "$1" = "config" ]; then fi -delay=`psql -d nominatim -c 'copy (select extract(epoch from now()-lastimportdate)::int from import_status) to stdout'` +delay=`psql -d nominatim -c 'copy (select extract(epoch from timezone('utc', now())-lastimportdate)::int from import_status) to stdout'` echo "age.value $delay"