Mercurial > gemma
annotate docker/Dockerfile.geoserv @ 4449:ce884af9f42f
Fix forecast accuracy values and improve performance
Forecast accuracy should be based only on the most recent predictions.
Generally consider measurements and predictions older than 14 days as
outdated and irrelevant. This also implies a performance gain, since it
saves a full scan of gauge_measurements and the extra index for this
purpose.
Adding an extra subquery level for calculation of the forecast accuracy per
row instead of the function call as a FROM item saves a (nested loop)
join, which is another performance gain.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 20 Sep 2019 13:22:45 +0200 |
parents | a524e7d7e75f |
children | a63df1ac39ac |
rev | line source |
---|---|
458 | 1 FROM ubuntu:bionic |
2 LABEL authors="tom@intevation.de" | |
1356
ce24990b3d5c
add licensing hint to docker files
Bernhard Reiter <bernhard@intevation.de>
parents:
1269
diff
changeset
|
3 LABEL description="Contains software from gemma, for right holders and\ |
ce24990b3d5c
add licensing hint to docker files
Bernhard Reiter <bernhard@intevation.de>
parents:
1269
diff
changeset
|
4 licensing infos, see https://hg.intevation.de/gemma ." |
458 | 5 |
528
076996a41c31
fix: Dockerfile.geoserv - adding "universe" to sources.list
Thomas Junk <thomas.junk@intevation.de>
parents:
458
diff
changeset
|
6 RUN sed -i 's/\(deb.*\)$/\1 universe/' /etc/apt/sources.list |
458 | 7 |
8 RUN apt-get update &&\ | |
9 apt-get -y install --no-install-recommends \ | |
528
076996a41c31
fix: Dockerfile.geoserv - adding "universe" to sources.list
Thomas Junk <thomas.junk@intevation.de>
parents:
458
diff
changeset
|
10 curl unzip openjdk-8-jre-headless tomcat8 |
458 | 11 |
12 ENV CATALINA_HOME /usr/share/tomcat8 | |
13 ENV CATALINA_BASE /var/lib/tomcat8 | |
14 ENV CATALINA_TMPDIR /tmp/tomcat8-tmp | |
15 | |
2236
32441ac04c7c
Reverted accidentally updated Dockerfiles.
Bjoern Schilberg <bjoern@intevation.de>
parents:
2235
diff
changeset
|
16 ENV GS_URL https://downloads.sourceforge.net/project/geoserver/GeoServer |
2235
39586a34979c
LAYERS.WATERWAYPROFILES: Set max- and minResolution. Modelled after d4d.
Bjoern Schilberg <bjoern@intevation.de>
parents:
1925
diff
changeset
|
17 |
4297
a524e7d7e75f
Use newest stable release of GeoServer
Tom Gottfried <tom@intevation.de>
parents:
3322
diff
changeset
|
18 ENV GS_VERSION 2.15.2 |
458 | 19 ENV GS_DATADIR /opt/geoserver/data |
20 | |
21 ENV CATALINA_OPTS="-DGEOSERVER_DATA_DIR=$GS_DATADIR" | |
22 | |
23 RUN mkdir -p $GS_DATADIR && chown tomcat8 $GS_DATADIR | |
24 | |
25 RUN curl -L $GS_URL/$GS_VERSION/geoserver-$GS_VERSION-war.zip > gs.zip &&\ | |
26 unzip -d $CATALINA_BASE/webapps/ gs.zip geoserver.war &&\ | |
27 rm gs.zip | |
28 | |
29 EXPOSE 8080 | |
30 | |
31 USER tomcat8 | |
32 | |
33 RUN mkdir $CATALINA_TMPDIR | |
34 | |
35 CMD ["/usr/share/tomcat8/bin/catalina.sh", "run"] |