Mercurial > lada > lada-server
view db_schema/Dockerfile @ 1315:84bb7e2aecb1
Do not redefine existing operator.
The removed SQL failed on PostgreSQL 9.5 because the operator is
provided and needed by the system. Further, it does not seem to be
used here.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 17 Mar 2017 13:25:57 +0100 |
parents | 902bc2190fec |
children | 5a62a68bccf5 |
line wrap: on
line source
# Docker file for postgresql 9.5 on debain # # build with e.g. `docker build --force-rm=true -t koala/lada_db .', # then run with e.g. # `docker run --name lada_db -dp 2345:5432 koala/lada_db:latest' # # For easier testing of schema or example data changes, it can be useful to add # `-v $PWD:/opt/lada_sql/' and run setup-db.sh within the container. # FROM debian:jessie MAINTAINER tom.gottfried@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 curl unzip make gcc RUN echo "deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main" \ >> /etc/apt/sources.list RUN curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add - RUN apt-get update && \ apt-get install -y --no-install-recommends \ postgresql-9.5-postgis-2.3 postgresql-9.5-postgis-scripts postgis # # 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.5/main/pg_hba.conf RUN echo "listen_addresses='*'" >> /etc/postgresql/9.5/main/postgresql.conf # # 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 . /opt/lada_sql/ WORKDIR /opt/lada_sql/ RUN /usr/lib/postgresql/9.5/bin/pg_ctl start -wD /etc/postgresql/9.5/main/ && \ /opt/lada_sql/setup-db.sh # # Set the default command to run when starting the container # CMD ["/usr/lib/postgresql/9.5/bin/postgres", "-D", \ "/var/lib/postgresql/9.5/main", "-c", \ "config_file=/etc/postgresql/9.5/main/postgresql.conf"]