# This is modified Dockerfile from 16/bookworm in

# https://github.com/docker-library/postgres

# Set UBUNTU_VERSION = [ devel 24.10 24.04 22.04 20.04 ]

# or [ devel oracular noble jammy focal ]

ARG UBUNTU_VERSION=noble

FROM ubuntu:${UBUNTU_VERSION}

ARG UBUNTU_VERSION

# Set PG_MAJOR = [ 17 16 ]

ARG PG_MAJOR=17

ENV PG_MAJOR=${PG_MAJOR}

# set compiler: [ clang gcc ]

ARG BUILD_CC_COMPILER=clang

ENV BUILD_CC_COMPILER=${BUILD_CC_COMPILER}

# Enable debug mode and preserve the build environments for debugging.

# In this case, each image size exceeds ~1GB

ARG DEBUG_MODE=false

ENV DEBUG_MODE=${DEBUG_MODE}

# Define build dependencies for LLVM [ llvm-dev clang ]

# These include the specific versions of 'llvm-dev' and 'clang' suitable for the current version of PostgreSQL.

# Reference: https://github.com/docker-library/postgres/pull/1077

ARG DOCKER_PG_LLVM_DEPS="llvm-dev clang"

ENV DOCKER_PG_LLVM_DEPS=${DOCKER_PG_LLVM_DEPS}

# explicitly set user/group IDs

RUN set -eux; \

groupadd -r postgres --gid=999; \

# https://salsa.debian.org/postgresql/postgresql-common/blob/997d842ee744687d99a2b2d95c1083a2615c79e8/debian/postgresql-common.postinst#L32-35

useradd -r -g postgres --uid=999 --home-dir=/var/lib/postgresql --shell=/bin/bash postgres; \

# also create the postgres user's home directory with appropriate permissions

# see https://github.com/docker-library/postgres/issues/274

mkdir -p /var/lib/postgresql; \

chown -R postgres:postgres /var/lib/postgresql

RUN set -eux; \

apt-get update; \

DEBIAN_FRONTEND=noninteractive apt-get full-upgrade -y; \

DEBIAN_FRONTEND=noninteractive apt-get install -y --no-install-recommends \

ca-certificates \

gnupg \

locales \

tzdata \

\

# Ensures compatibility with the official PostgreSQL Docker image

libnss-wrapper \

xz-utils \

zstd \

; \

echo 'en_US.UTF-8 UTF-8' >> /etc/locale.gen; \

locale-gen; \

locale -a | grep 'en_US.utf8' ; \

\

rm -rf /var/lib/apt/lists/* ; \

apt-get clean

# make the "en_US.UTF-8" locale so postgres will be utf-8 enabled by default

ENV LANG=en_US.utf8

# grab gosu for easy step-down from root

# https://github.com/tianon/gosu/releases

ENV GOSU_VERSION=1.17

RUN set -eux; \

savedAptMark="$(apt-mark showmanual)"; \

apt-get update; \

apt-get install -y --no-install-recommends ca-certificates wget; \

rm -rf /var/lib/apt/lists/*; \

dpkgArch="$(dpkg --print-architecture | awk -F- '{ print $NF }')"; \

wget -O /usr/local/bin/gosu "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch"; \

wget -O /usr/local/bin/gosu.asc "https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-$dpkgArch.asc"; \

export GNUPGHOME="$(mktemp -d)"; \

gpg --batch --keyserver hkps://keys.openpgp.org --recv-keys B42F6819007F00F88E364FD4036A9C25BF357DD4; \

gpg --batch --verify /usr/local/bin/gosu.asc /usr/local/bin/gosu; \

gpgconf --kill all; \

rm -rf "$GNUPGHOME" /usr/local/bin/gosu.asc; \

apt-mark auto '.*' > /dev/null; \

[ -z "$savedAptMark" ] || apt-mark manual $savedAptMark > /dev/null; \

apt-get purge -y --auto-remove -o APT::AutoRemove::RecommendsImportant=false; \

chmod +x /usr/local/bin/gosu; \

gosu --version; \

gosu nobody true

RUN mkdir -p /usr/src/postgresql/contrib/orioledb

COPY . /usr/src/postgresql/contrib/orioledb

RUN mkdir /docker-entrypoint-initdb.d

RUN mkdir -p /var/run/postgresql && chown -R postgres:postgres /var/run/postgresql && chmod 2777 /var/run/postgresql

ENV PATH=$PATH:/usr/lib/postgresql/$PG_MAJOR/bin

RUN set -eux; \

\

PGTAG=$(grep "^$PG_MAJOR: " /usr/src/postgresql/contrib/orioledb/.pgtags | cut -d' ' -f2-) ; \

ORIOLEDB_VERSION=$(grep "^#define ORIOLEDB_VERSION" /usr/src/postgresql/contrib/orioledb/include/orioledb.h | cut -d'"' -f2) ; \

ORIOLEDB_BUILDTIME=$(date -Iseconds) ; \

\

echo "PG_MAJOR=$PG_MAJOR" ; \

echo "PGTAG=$PGTAG" ; \

echo "BUILD_CC_COMPILER=$BUILD_CC_COMPILER" ; \

echo "ORIOLEDB_VERSION=$ORIOLEDB_VERSION" ; \

echo "ORIOLEDB_BUILDTIME=$ORIOLEDB_BUILDTIME" ; \

echo "DOCKER_PG_LLVM_DEPS=$DOCKER_PG_LLVM_DEPS" ; \

echo "DEBUG_MODE=$DEBUG_MODE" ; \

\

LLVM_RUNTIME_DEPS=$(echo "$DOCKER_PG_LLVM_DEPS" | grep -o 'llvm[0-9]*') ; \

echo "LLVM_RUNTIME_DEPS=$LLVM_RUNTIME_DEPS" ; \

\

apt-get update; \

DEBIAN_FRONTEND=noninteractive apt-get -y install --no-install-recommends \

build-essential \

${LLVM_RUNTIME_DEPS} \

${DOCKER_PG_LLVM_DEPS} \

bison \

curl \

flex \

gdb \

git \

libcurl4-openssl-dev \

libicu-dev \

libipc-run-perl \

libkrb5-dev \

libldap-dev \

liblz4-1 \

liblz4-dev \

libperl-dev \

libssl-dev \

libreadline-dev \

libuuid1 \

libxml2 \

libxml2-dev \

libxslt1.1 \

libxslt1-dev \

libzstd1 \

libzstd-dev \

make \

pkg-config \

python3 \

python3-dev \

python3-pip \

python3-setuptools \

python3-testresources \

tcl-dev \

uuid-dev \

wget \

; \

\

curl -o postgresql.tar.gz \

--header "Accept: application/vnd.github.v3.raw" \

--remote-name \

--location https://github.com/orioledb/postgres/tarball/$PGTAG; \

mkdir -p /usr/src/postgresql; \

tar \

--extract \

--file postgresql.tar.gz \

--directory /usr/src/postgresql \

--strip-components 1 \

; \

rm postgresql.tar.gz; \

\

cd /usr/src/postgresql; \

\

POSTGRESQL_VERSION=$(grep "PACKAGE_VERSION=" ./configure | cut -d"'" -f2) ; \

echo "POSTGRESQL_VERSION=$POSTGRESQL_VERSION" ; \

\

gnuArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)"; \

# explicitly update autoconf config.guess and config.sub so they support more arches/libcs

wget --tries=10 --timeout=60 -O config/config.guess 'https://git.savannah.gnu.org/cgit/config.git/plain/config.guess?id=7d3d27baf8107b630586c962c057e22149653deb'; \

wget --tries=10 --timeout=60 -O config/config.sub 'https://git.savannah.gnu.org/cgit/config.git/plain/config.sub?id=7d3d27baf8107b630586c962c057e22149653deb'; \

# configure options taken from:

# https://anonscm.debian.org/cgit/pkg-postgresql/postgresql.git/tree/debian/rules?h=9.5

( CC=${BUILD_CC_COMPILER} ./configure \

--build="$gnuArch" \

# "/usr/src/postgresql/src/backend/access/common/tupconvert.c:105: undefined reference to `libintl_gettext'"

# --enable-nls \

--enable-integer-datetimes \

--enable-thread-safety \

--enable-tap-tests \

# skip debugging info -- we want tiny size instead

# --enable-debug \

--disable-rpath \

--with-uuid=e2fs \

--with-gnu-ld \

--with-pgport=5432 \

--with-system-tzdata=/usr/share/zoneinfo \

--prefix=/usr/local \

--with-includes=/usr/local/include \

--with-libraries=/usr/local/lib \

--with-krb5 \

--with-gssapi \

--with-ldap \

--with-tcl \

--with-perl \

--with-python \

# --with-pam \

--with-openssl \

--with-libxml \

--with-libxslt \

--with-icu \

--with-llvm \

--with-lz4 \

--with-zstd \

# The "testgres" package expects the PostgreSQL version as the last word.

# Therefore, the extra ${POSTGRESQL_VERSION} is added as a workaround.

--with-extra-version=" ${ORIOLEDB_VERSION} PGTAG=${PGTAG} ubuntu:${UBUNTU_VERSION}+${BUILD_CC_COMPILER} build:${ORIOLEDB_BUILDTIME} ${POSTGRESQL_VERSION}" \

|| cat config.log ); \

echo "ORIOLEDB_PATCHSET_VERSION = `echo $PGTAG | cut -d'_' -f2`" >> src/Makefile.global; \

# install postgresql

make -j "$(nproc)"; \

make -C contrib -j "$(nproc)"; \

make install; \

make -C contrib install; \

# install orioledb extension

cd /usr/src/postgresql/contrib/orioledb; \

make USE_PGXS=1 -j "$(nproc)"; \

make USE_PGXS=1 install; \

\

# Clean up only if not in debug mode

if [ "$DEBUG_MODE" != "true" ]; then \

apt-get -y remove \

${DOCKER_PG_LLVM_DEPS} \

bison \

build-essential \

curl \

flex \

gdb \

git \

libicu-dev \

libipc-run-perl \

liblz4-dev \

libreadline-dev \

libxml2-dev \

libxslt1-dev \

libzstd-dev \

make \

pkg-config \

python3-dev \

python3-pip \

uuid-dev \

wget \

; \

apt-get -y autoremove; \

rm -rf /var/cache/apt/archives /var/lib/apt/lists/*; \

apt-get clean; \

rm -rf \

/usr/src/postgresql \

/usr/local/share/doc \

/usr/local/share/man \

/tmp/* \

; \

fi ; \

\

cd /; \

# Verify PostgreSQL installation

ldconfig ; \

postgres --version ; \

initdb --version

ENV PGDATA=/var/lib/postgresql/data

# this 777 will be replaced by 700 at runtime (allows semi-arbitrary "--user" values)

RUN mkdir -p "$PGDATA" && chown -R postgres:postgres "$PGDATA" && chmod 777 "$PGDATA"

VOLUME /var/lib/postgresql/data

RUN mkdir -p /etc/postgresql && chown -R postgres:postgres /etc/postgresql && chmod 700 /etc/postgresql

COPY --chown=postgres:postgres postgresql.docker.conf /etc/postgresql/postgresql.conf

ENV PG_CONF=/etc/postgresql/postgresql.conf

COPY docker-entrypoint.sh /usr/local/bin/

RUN sed -i -e 's/su-exec/gosu/g' "/usr/local/bin/docker-entrypoint.sh"

ENTRYPOINT ["docker-entrypoint.sh"]

# We set the default STOPSIGNAL to SIGINT, which corresponds to what PostgreSQL

# calls "Fast Shutdown mode" wherein new connections are disallowed and any

# in-progress transactions are aborted, allowing PostgreSQL to stop cleanly and

# flush tables to disk, which is the best compromise available to avoid data

# corruption.

#

# Users who know their applications do not keep open long-lived idle connections

# may way to use a value of SIGTERM instead, which corresponds to "Smart

# Shutdown mode" in which any existing sessions are allowed to finish and the

# server stops when all sessions are terminated.

#

# See https://www.postgresql.org/docs/12/server-shutdown.html for more details

# about available PostgreSQL server shutdown signals.

#

# See also https://www.postgresql.org/docs/12/server-start.html for further

# justification of this as the default value, namely that the example (and

# shipped) systemd service files use the "Fast Shutdown mode" for service

# termination.

#

STOPSIGNAL SIGINT

#

# An additional setting that is recommended for all users regardless of this

# value is the runtime "--stop-timeout" (or your orchestrator/runtime's

# equivalent) for controlling how long to wait between sending the defined

# STOPSIGNAL and sending SIGKILL (which is likely to cause data corruption).

#

# The default in most runtimes (such as Docker) is 10 seconds, and the

# documentation at https://www.postgresql.org/docs/12/server-start.html notes

# that even 90 seconds may not be long enough in many instances.

EXPOSE 5432

CMD ["postgres", "-D", "/etc/postgresql"]