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

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 WAMOS role and database
ADD wamos.sql .
RUN $PGBIN/pg_ctl start -wo "--config_file=$PGCONF" && \
    psql -c "CREATE USER wamos PASSWORD 'wamos'" && \
    createdb wamos && \
    psql -f wamos.sql -d wamos && \
    $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"]