Dockerfile

FROM postgres:12.4

LABEL maintainer="Andreas.Buckenhofer@gmail.com"
LABEL org.label-schema.schema-version="1.3"
LABEL org.label-schema.name="ColumnarPostgreSQL"
LABEL org.label-schema.description="PostgreSQL with columnstore cstore extension for analytical workloads"
LABEL org.label-schema.url="https://github.com/citusdata/cstore_fdw"
LABEL org.label-schema.vcs-url = "https://github.com/abuckenhofer/columnarpostgresql"
LABEL org.label-schema.docker.cmd="docker run -d -p 5432:5432 -e POSTGRES_PASSWORD=setpassword --name columnarpostgresql abuckenhofer/columnarpostgresql:latest"

## required for cstore_fdw
RUN apt-get update -y -qq && \
    apt-get -y -qq install protobuf-c-compiler libprotobuf-c-dev unzip git build-essential

## required for building and installing extensions
RUN apt-get update \
    && apt-get install -y \
        postgresql-server-dev-12 \
        postgresql-common \
    && rm -rf /var/lib/apt/lists/*

## install cstore_fdw extension
WORKDIR /usr/src
RUN git clone https://github.com/citusdata/cstore_fdw.git && \
    cd cstore_fdw && \
    make install && \
    cd .. && \
    rm -rf cstore_fdw

## add cstore_fdw to PostgreSQL config
RUN sed -i "s/#shared_preload_libraries = ''/shared_preload_libraries = 'cstore_fdw'/g" /usr/share/postgresql/postgresql.conf.sample

## add sample files into container
RUN git clone https://github.com/abuckenhofer/dwh_course.git
WORKDIR /usr/src/dwh_course

USER postgres