From 129c66a34542b76fe6784143e4029c51e09153b9 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Fri, 27 Apr 2012 00:05:55 +0200 Subject: [PATCH] timezone trouble --- munin/nominatim_importlag | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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" -- 2.39.5