Merge remote-tracking branch 'upstream/master'

[nominatim.git] / munin / nominatim_importlag

diff --git a/munin/nominatim_importlag b/munin/nominatim_importlag
index 8d69f3cee7d3ded8472ca9dbc6ec2c0d7a002152..9f40131194aa2ee18e6a1fd97b9d08fd0f0dc1d6 100755 (executable)
--- a/munin/nominatim_importlag
+++ b/munin/nominatim_importlag
@@ -2,6 +2,9 @@
 #
 # Plugin to monitor the age of the imported data in the rendering db
 #
 #
 # Plugin to monitor the age of the imported data in the rendering db
 #

+# Can be configured through libpq environment variables, for example
+# PGUSER, PGDATABASE, etc. See man page of psql for more information
+#

 # Parameters: 
 #
 #       config   (required)
 # Parameters: 
 #
 #       config   (required)


@@ -21,7 +24,7 @@ if [ "$1" = "config" ]; then
 fi
  
 
 fi
  
 

-delay=`psql -d nominatim -c 'copy (select extract(epoch from now()-lastimportdate)::int from import_status) to stdout'`
+delay=`psql -c "copy (select extract(epoch from timezone('utc', now())-lastimportdate)::int from import_status) to stdout"`

  
  
 echo "age.value $delay"
  
  
 echo "age.value $delay"