#
# Docker file to create postgres image for ssdt applications

FROM postgres:9.6.11

MAINTAINER Dave Smith smith@nwoca.org

ENV DB_NAME=database \
    DB_USER=dbuser \
    DB_PASS=dbpassword \
    PGDATA=/var/lib/postgresql/data/pgdata

COPY setupDatabase.sh /docker-entrypoint-initdb.d/setupDatabase.sh

COPY setupExtensions.sh /docker-entrypoint-initdb.d/setupExtensions.sh

RUN chmod 755 /docker-entrypoint-initdb.d/setupDatabase.sh \
    & chmod 755 /docker-entrypoint-initdb.d/setupExtensions.sh

ENV TZ=America/New_York

RUN     echo $TZ > /etc/timezone \
    &&  dpkg-reconfigure --frontend noninteractive tzdata
    
COPY ssdt-entrypoint.sh /usr/local/bin/

RUN chmod 755 /usr/local/bin/ssdt-entrypoint.sh

LABEL "io.ssdt.type"="db"

ENTRYPOINT ["ssdt-entrypoint.sh"]

CMD ["postgres"]