Dockerfile

ARG POSTGRES_MAJOR_VERSION=14
ARG POSTGRES_MINOR_VERSION=4

# Build stage. Used to build the pg_sphere extension from source.
FROM ghcr.io/cloudnative-pg/postgresql:${POSTGRES_MAJOR_VERSION}.${POSTGRES_MINOR_VERSION} as build
# Make the Postgres major version available to the build
ARG POSTGRES_MAJOR_VERSION

WORKDIR /build 

USER root

# Install build dependencies. Check lower in the file for where to install
# runtime packages.
RUN apt-get update && apt-get install -qq -y \
    git \
    pkgconf \
    build-essential \
    postgresql-server-dev-${POSTGRES_MAJOR_VERSION} \
    libhealpix-cxx-dev \
    postgresql-common \
    # Begin pg_bulkload deps
    libpam-dev                      \
    libkrb5-dev                     \
    libssl-dev                      \
    libreadline-dev                 \
    libselinux-dev                  \
    libedit-dev                     \
    liblz4-dev                      \
    zlib1g-dev                      \
    # End pg_bulkload deps
    && rm -rf /var/lib/apt/lists/*

# Build pg_sphere from source. Needed to do this because at the time of writing
# version 1.1 is the latest package available in the apt.postgresql.org repo, but
# version 1.2 was needed.
RUN git clone https://github.com/postgrespro/pgsphere.git \
    && cd pgsphere \
    && gmake USE_PGXS=1 PG_CONFIG=/usr/bin/pg_config CPPFLAGS+=-I/usr/include/healpix_cxx \
    && gmake USE_PGXS=1 PG_CONFIG=/usr/bin/pg_config install

# Build pg_bulkload from source because as of writing it does note exist in the
# apt.postgresql.org repo    
WORKDIR /build
RUN git clone https://github.com/ossc-db/pg_bulkload --depth 1 --branch VERSION3_1_20 \
    && cd pg_bulkload \
    && make USE_PGXS=1 \
    && make USE_PGXS=1 install

# Runtime image
FROM ghcr.io/cloudnative-pg/postgresql:${POSTGRES_MAJOR_VERSION}.${POSTGRES_MINOR_VERSION}
ARG POSTGRES_MAJOR_VERSION

USER root

# Runtime Debian packages can be installed below, including postgres extensions from
# the apt.postgresql.org repo. Extensions can generally be found named like:
# "postgresql-<major_version>-<extenstion_name>"
# Use "${POSTGRES_MAJOR_VERSION}" as the verion parameter in packages to maintain
# compatability.
# There's not a super great way to list packages in the postgres repo outside of
# installing the repo on a Debian-based system and using the apt tools to query
# against it. However, the below commands can be adapted to locate available
# packages. Curl can show you the full list of package names available:
#
# curl https://apt.postgresql.org/pub/repos/apt/dists/buster-pgdg/main/binary-amd64/Packages 2> /dev/null | grep Package: | grep -v Auto-Built | less
#
# Or with Docker you can use apt-cache to search for keywords:
#
# docker run --user 0 --rm postgres bash -c "apt-get update && apt-cache search postgresql-14"
RUN apt-get update && apt-get install -qq -y \
    libhealpix-cxx2 \
    postgresql-${POSTGRES_MAJOR_VERSION}-cron \
    postgresql-${POSTGRES_MAJOR_VERSION}-partman \
    && rm -rf /var/lib/apt/lists/*

# Copy the pg_sphere build artifacts from the above build stage
COPY --from=build /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/bitcode/pg_sphere/ /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/bitcode/pg_sphere/
COPY --from=build /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/pg_sphere.so /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/pg_sphere.so
COPY --from=build /usr/share/postgresql/${POSTGRES_MAJOR_VERSION}/extension/pg_sphere* /usr/share/postgresql/${POSTGRES_MAJOR_VERSION}/extension/

# Copy pg_bulkload build artifacts
COPY --from=build /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/bin/pg_bulkload /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/bin/pg_bulkload
COPY --from=build /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/pg_bulkload.so /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/pg_bulkload.so
COPY --from=build /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/pg_timestamp.so /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/pg_timestamp.so
COPY --from=build /usr/share/postgresql/${POSTGRES_MAJOR_VERSION}/extension/pg_bulkload* /usr/share/postgresql/${POSTGRES_MAJOR_VERSION}/extension/
COPY --from=build /usr/share/postgresql/${POSTGRES_MAJOR_VERSION}/extension/uninstall_pg_bulkload.sql /usr/share/postgresql/${POSTGRES_MAJOR_VERSION}/extension/uninstall_pg_bulkload.sql 
COPY --from=build /usr/share/postgresql/${POSTGRES_MAJOR_VERSION}/contrib/pg_timestamp.sql /usr/share/postgresql/${POSTGRES_MAJOR_VERSION}/contrib/pg_timestamp.sql
COPY --from=build /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/bitcode/pg_timestamp/ /usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/bitcode/pg_timestamp/
# RUN cd '/usr/lib/postgresql/${POSTGRES_MAJOR_VERSION}/lib/bitcode' && /usr/lib/llvm-11/bin/llvm-lto -thinlto -thinlto-action=thinlink -o pg_timestamp.index.bc pg_timestamp/pg_timestamp.bc

USER postgres