Dockerfile

FROM postgres:12 AS build

ARG USE_POSTGIS=true
ENV PLUGIN_VERSION=v1.7.0.Final
ENV PROTOC_VERSION=1.3

ENV WAL2JSON_COMMIT_ID=92b33c7d7c2fccbeb9f79455dafbc92e87e00ddd

# Install the packages which will be required to get everything to compile
RUN apt-get update \
    && apt-get install -f -y --no-install-recommends \
        software-properties-common \
        build-essential \
        pkg-config \
        git \
        postgresql-server-dev-$PG_MAJOR \
    && apt-get update && apt-get install -f -y --no-install-recommends \
        libprotobuf-c-dev=$PROTOC_VERSION.* \
    && rm -rf /var/lib/apt/lists/*

# Compile the plugin from sources and install it
RUN git clone https://github.com/debezium/postgres-decoderbufs -b $PLUGIN_VERSION --single-branch \
    && cd /postgres-decoderbufs \
    && make && make install \
    && cd / \
    && rm -rf postgres-decoderbufs

RUN git clone https://github.com/eulerto/wal2json -b master --single-branch \
    && cd /wal2json \
    && git checkout $WAL2JSON_COMMIT_ID \
    && make && make install \
    && cd / \
    && rm -rf wal2json

FROM postgres:12

# install pgcron
RUN apt-get update \
      && apt-get install postgresql-12-cron postgresql-12-pldebugger -y

ENV JWT_SECRET = "3EK6FD+o0+c7tzBNVfjpMkNDi2yARAAKzQlk8O2IKoxQu4nF7EdAh8s3TwpHwrdWT6R"
ENV COURIER_URL="http://localhost:8883"

# install postgis
ENV POSTGIS_MAJOR 3
ENV POSTGIS_VERSION 3.0.0+dfsg-2~exp1.pgdg100+1
RUN apt-get update \
      && apt-cache showpkg postgresql-$PG_MAJOR-postgis-$POSTGIS_MAJOR \
      && apt-get install -y --no-install-recommends \
          postgresql-$PG_MAJOR-postgis-$POSTGIS_MAJOR \
          postgresql-$PG_MAJOR-postgis-$POSTGIS_MAJOR-scripts \
      && apt-get update \
      && apt-get install -y --no-install-recommends \
          libprotobuf-c1 \
      && rm -rf /var/lib/apt/lists/* /var/tmp/*

# install pgtap
ENV PGTAP_VERSION=v1.1.0

RUN pgtapDependencies="git \
    ca-certificates \
    build-essential" \
    && apt-get update \
    && apt-get install -y --no-install-recommends ${pgtapDependencies} \
    && cd /tmp \
    && git clone git://github.com/theory/pgtap.git \
    && cd pgtap \
    && git checkout tags/$PGTAP_VERSION \
    && make install \
    && apt-get clean \
    && apt-get remove -y ${pgtapDependencies} \
    && apt-get autoremove -y \
    && rm -rf /tmp/pgtap /var/lib/apt/lists/* /var/tmp/*

# install pgAudit
ENV PGAUDIT_VERSION=1.4.0

RUN pgAuditDependencies="git \
    ca-certificates \
    build-essential \
    postgresql-server-dev-$PG_MAJOR \
    libssl-dev \
    libkrb5-dev" \
    && apt-get update \
    && apt-get install -y --no-install-recommends ${pgAuditDependencies} \
    && cd /tmp \
    && git clone https://github.com/pgaudit/pgaudit.git \
    && cd pgaudit \
    && git checkout ${PGAUDIT_VERSION} \
    && make check USE_PGXS=1 \
    && make install USE_PGXS=1 \
    && apt-get clean \
    && apt-get remove -y ${pgAuditDependencies} \
    && apt-get autoremove -y \
    && rm -rf /tmp/pgaudit /var/lib/apt/lists/* /var/tmp/*

# install pgjwt
RUN pgjwtDependencies="git \
    ca-certificates \
    build-essential" \
    && apt-get update \
    && apt-get install -y --no-install-recommends ${pgjwtDependencies} \
    && cd /tmp \
    && git clone https://github.com/michelp/pgjwt.git \
    && cd pgjwt \
    && git checkout master \
    && make install \
    && apt-get clean \
    && apt-get remove -y ${pgtapDependencies} \
    && apt-get autoremove -y \
    && rm -rf /tmp/pgjwt /var/lib/apt/lists/* /var/tmp/*

# install pgsql-http
ENV PGSQL_HTTP_VERSION=v1.3.1

RUN pgsqlHttpDependencies="git \
    ca-certificates \
    build-essential \
    postgresql-server-dev-$PG_MAJOR" \
    && pgsqlHttpRuntimeDependencies="libcurl4-gnutls-dev" \
    && apt-get update \
    && apt-get install -y --no-install-recommends ${pgsqlHttpDependencies} ${pgsqlHttpRuntimeDependencies} \
    && cd /tmp \
    && git clone https://github.com/pramsey/pgsql-http.git \
    && cd pgsql-http \
    && git checkout ${PGSQL_HTTP_VERSION} \
    && make \
    && make install \
    && apt-get clean \
    && apt-get remove -y ${pgsqlHttpDependencies} \
    && apt-get autoremove -y \
    && rm -rf /tmp/pgsql-http /var/lib/apt/lists/* /var/tmp/*

# install plpgsql_check
ENV PLPGSQL_CHECK_VERSION=v1.11.3

RUN plpgsqlCheckDependencies="git \
    ca-certificates \
    build-essential \
    postgresql-server-dev-$PG_MAJOR" \
    && plpgsqlCheckRuntimeDependencies="libicu-dev" \
    && apt-get update \
    && apt-get install -y --no-install-recommends ${plpgsqlCheckDependencies} ${plpgsqlCheckRuntimeDependencies} \
    && cd /tmp \
    && git clone https://github.com/okbob/plpgsql_check.git \
    && cd plpgsql_check \
    && git checkout ${PLPGSQL_CHECK_VERSION} \
    && make clean \
    && make install \
    && apt-get clean \
    && apt-get remove -y ${pgsqlHttpDependencies} \
    && apt-get autoremove -y \
    && rm -rf /tmp/plpgsql_check /var/lib/apt/lists/* /var/tmp/*

# install pg-safeupdate
ENV PGSAFEUPDATE_VERSION=1.3

RUN pgSafeUpdateDependencies="pgxnclient \
postgresql-server-dev-12" \
&& apt-get update \
&& apt-get install -y --no-install-recommends ${pgSafeUpdateDependencies} \
&& cd /tmp \
&& git clone https://github.com/eradman/pg-safeupdate.git \
&& cd pg-safeupdate \
&& git checkout ${PGSAFEUPDATE_VERSION} \
&& make \
&& make install \
&& apt-get clean \
&& apt-get remove -y ${pgSafeUpdateDependencies} \
&& apt-get autoremove -y \
&& rm -rf /tmp/pg-safeupdate /var/lib/apt/lists/* /var/tmp/*

# install pljava
ENV PLJAVA_VERSION=V1_6_0

RUN pljavaDependencies="git \
    ca-certificates \
    g++ \
    maven \
    postgresql-server-dev-$PG_MAJOR \
    libpq-dev \
    libecpg-dev \
    libkrb5-dev \
    default-jdk \
    libssl-dev" \
    && apt-get update \
    && apt-get install -y --no-install-recommends ${pljavaDependencies} \
    && cd /tmp \
    && git clone https://github.com/tada/pljava.git \
    && cd pljava \
    && git checkout ${PLJAVA_VERSION} \
    && mvn clean install \
    && java -jar pljava-packaging/target/pljava-pg12.jar \
    && apt-get clean \
    && apt-get remove -y ${pljavaDependencies} \
    && apt-get autoremove -y \
    && rm -rf ~/.m2 /tmp/pljava /var/lib/apt/lists/* /var/tmp/*

RUN apt-get update \
    && apt-get install -y --no-install-recommends default-jdk-headless \
    && rm -rf /var/lib/apt/lists/* /var/tmp/*

ENV LANGUAGE=en_US.UTF-8
ENV LANG=en_US.UTF-8
ENV LC_ALL=en_US.UTF-8

RUN mkdir -p /docker-entrypoint-initdb.d

COPY --from=build /usr/lib/postgresql/$PG_MAJOR/lib/decoderbufs.so /usr/lib/postgresql/$PG_MAJOR/lib/wal2json.so /usr/lib/postgresql/$PG_MAJOR/lib/
COPY --from=build /usr/share/postgresql/$PG_MAJOR/extension/decoderbufs.control /usr/share/postgresql/$PG_MAJOR/extension/

COPY ./scripts/00-init-permissions.sh /docker-entrypoint-initdb.d
COPY ./scripts/01-extensions-schema.sql /docker-entrypoint-initdb.d
COPY ./scripts/02-notify-function.sql /docker-entrypoint-initdb.d
COPY ./scripts/03-roles-schemas.sql /docker-entrypoint-initdb.d

#ADD ./mnt /docker-entrypoint-initdb.d/