Docker PostGis With Citus Extension

001-create-citus-extension.sql

CREATE EXTENSION IF NOT EXISTS citus;

Dockerfile

#https://github.com/citusdata/docker/blob/v10.2.5/001-create-citus-extension.sql

FROM postgis/postgis:13-3.1

ARG VERSION=10.2.5

ENV CITUS_VERSION ${VERSION}.citus-1

# install Citus, for Columnar Storage
RUN apt-get update \
    && apt-get install -y --no-install-recommends \
       ca-certificates \
       curl \
    && curl -s https://install.citusdata.com/community/deb.sh | bash \
    && apt-get install -y postgresql-$PG_MAJOR-citus-10.2=$CITUS_VERSION \
                          postgresql-$PG_MAJOR-hll=2.16.citus-1 \
                          postgresql-$PG_MAJOR-topn=2.4.0 \
    && apt-get purge -y --auto-remove curl \
    && rm -rf /var/lib/apt/lists/*

# add citus to default PostgreSQL config
RUN echo "shared_preload_libraries='citus'" >> /usr/share/postgresql/postgresql.conf.sample

# add scripts to run after initdb
COPY 001-create-citus-extension.sql /docker-entrypoint-initdb.d/