Dockerfile.db

FROM ubuntu:22.04

ENV TZ=America/New_York
RUN ln -snf /usr/share/zoneinfo/${TZ} /etc/localtime && echo ${TZ} > /etc/timezone

# Remove /var/lib/postgresql so that a new one will be initialized in the entrypoint.
RUN export DEBIAN_FRONTEND=noninteractive && \
    apt-get update && \
    apt-get install --no-install-recommends -y gosu locales postgis postgresql-14 \
                                               postgresql-14-postgis-3 \
                                               postgresql-14-postgis-3-scripts && \
    rm -rf /var/lib/postgresql/* && \
    echo "en_US.UTF-8 UTF-8" > /etc/locale.gen && \
    ln -snf /usr/share/zoneinfo/${TZ} /etc/localtime && \
    dpkg-reconfigure -f noninteractive locales tzdata && \
    apt-get clean

COPY cavedb/scripts/docker-db-entrypoint.sh /docker-db-entrypoint.sh

VOLUME ["/var/lib/postgresql"]

ENTRYPOINT ["/docker-db-entrypoint.sh"]