Mercurial > gemma
view schema/Dockerfile @ 116:dad6cf39691e
Renamed remaining wamos stuff to gemma.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Tue, 26 Jun 2018 16:40:44 +0200 |
parents | 25b28fd0e256 |
children | 4ade330e571e |
line wrap: on
line source
FROM centos:7 MAINTAINER tom.gottfried@intevation.de # Add the PostgreSQL PGP key to verify the official yum repository packages RUN rpm --import https://yum.postgresql.org/RPM-GPG-KEY-PGDG-10 # Add PostgreSQL's repository. It contains the most recent release # of PostgreSQL, 10: RUN yum -q -y install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm # Install PostgreSQL 10 and PostGIS RUN yum -q -y install postgresql10-server RUN yum -q -y install epel-release RUN yum -q -y install postgis24_10 pgtap10 USER postgres ENV PGBIN /usr/pgsql-10/bin/ # initdb PostgreSQL 10: ENV PGDATA /var/lib/pgsql/10/data RUN $PGBIN/initdb -E UTF8 2>&1 < /dev/null # Adjust PostgreSQL configuration so that remote connections to the # database are possible. ENV PGCONF /var/lib/pgsql/10/data/postgresql.conf RUN echo "host all all 0.0.0.0/0 md5" >> /var/lib/pgsql/10/data/pg_hba.conf RUN echo "listen_addresses='*'" >> $PGCONF # Expose the PostgreSQL port EXPOSE 5432 # Create GEMMA role and database ADD *.sql ./ RUN $PGBIN/pg_ctl start -wo "--config_file=$PGCONF" && \ psql -c "CREATE USER gemma PASSWORD 'gemma'" && \ createdb gemma && \ psql -f gemma.sql -d gemma && \ psql -f auth.sql -d gemma && \ $PGBIN/pg_ctl stop -m smart # Set the default command to run when starting the container CMD ["/usr/pgsql-10/bin/postgres", "-D", "/var/lib/pgsql/10/data"]