Mercurial > dive4elements > river
view docker/Dockerfile.db @ 9713:aef987124822 3.2.x
Do not rely on database default for setting hws_lines.official to 0
It's not under the control of the importer whether the field is rendered
into an INSERT statement, whether it's actually set or not. If it is
unset but rendered into the statement, the field would be set to NULL.
Thus, always set it explicitly.
While here, remove an unused import.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 12 Mar 2021 15:11:44 +0100 |
parents | 537fe44f2792 |
children | c3afc0274bba |
line wrap: on
line source
# Docker file for postgresql 9.4 on debain FROM debian:jessie MAINTAINER tom@intevation.de # # Use utf-8 # RUN echo \ "locales locales/locales_to_be_generated multiselect en_US.UTF-8 UTF-8" | \ debconf-set-selections && \ echo "locales locales/default_environment_locale select en_US.UTF-8" | \ debconf-set-selections RUN apt-get update -y && apt-get install -y locales ENV LC_ALL en_US.UTF-8 # # Install packages # RUN apt-get update && \ apt-get install -y postgresql-9.4-postgis-2.1 postgis curl # # Use user postgres to run the next commands # USER postgres RUN /etc/init.d/postgresql start && \ psql --command "CREATE USER admin WITH SUPERUSER PASSWORD 'secret';" # # Adjust PostgreSQL configuration so that remote connections to the # database are possible. # RUN echo "host all all 0.0.0.0/0 md5" >> \ /etc/postgresql/9.4/main/pg_hba.conf ENV PGCONF /etc/postgresql/9.4/main/postgresql.conf RUN echo "listen_addresses='*'" >> $PGCONF # # Expose the PostgreSQL port # EXPOSE 5432 # # Create database # # Don't mind scary messages like # 'FATAL: the database system is starting up'. # It's because of the -w # ADD ./backend/doc/schema /opt/d4eriver_db # Go to postgres home for write permissions WORKDIR /var/lib/postgresql ENV DATA_ARCH demodaten_3.1.10-bis-3.2.x.tar.gz RUN curl -k "https://wald.intevation.org/frs/download.php/2282/$DATA_ARCH" | \ tar xz ENV PGDATA /var/lib/postgresql/9.4/main RUN /usr/lib/postgresql/9.4/bin/pg_ctl start -wo "--config_file=$PGCONF" && \ /opt/d4eriver_db/postgresql-setup.sh && \ psql -f demodaten/d4e_demodata.dump.sql d4e && \ createuser -S -D -R seddb && \ psql -c "ALTER USER seddb WITH PASSWORD 'seddb'" && \ createdb seddb && \ psql -f demodaten/seddb_demodata.dump.sql seddb && \ psql -c "GRANT SELECT ON ALL TABLES IN SCHEMA public TO seddb" seddb && \ /usr/lib/postgresql/9.4/bin/pg_ctl stop # # Set the default command to run when starting the container # CMD ["/usr/lib/postgresql/9.4/bin/postgres", "-D", \ "/var/lib/postgresql/9.4/main", "-c", \ "config_file=/etc/postgresql/9.4/main/postgresql.conf"]