postgres (18.6)

Published 2026-11-11 02:30:24 +00:00 by getty

Installation

docker pull src.ci/srv/postgres:18.6
sha256:cb341ad871ddd8b0bc8656d796a3fb2976179a7dfbbd6409c148831bfd79e0ef

Image layers

# debian.sh --arch 'amd64' out/ 'trixie' '@1793827419'
RUN /bin/sh -c set -eux; apt-get update; apt-get install -y --no-install-recommends ca-certificates curl gnupg netbase sq wget ; apt-get dist-clean # buildkit
RUN /bin/sh -c set -eux; apt-get update; apt-get install -y --no-install-recommends git mercurial openssh-client subversion procps ; apt-get dist-clean # buildkit
RUN /bin/sh -c set -ex; apt-get update; apt-get install -y --no-install-recommends autoconf automake bzip2 default-libmysqlclient-dev dpkg-dev file g++ gcc imagemagick libbz2-dev libc6-dev libcurl4-openssl-dev libdb-dev libevent-dev libffi-dev libgdbm-dev libglib2.0-dev libgmp-dev libjpeg-dev libkrb5-dev liblzma-dev libmagickcore-dev libmagickwand-dev libmaxminddb-dev libncurses5-dev libncursesw5-dev libpng-dev libpq-dev libreadline-dev libsqlite3-dev libssl-dev libtool libwebp-dev libxml2-dev libxslt-dev libyaml-dev make patch unzip xz-utils zlib1g-dev ; apt-get dist-clean # buildkit
ARG SRV_UID=1000
ARG SRV_GID=100
ARG SRV_LOCALE=en_GB
ARG SRV_VERSION=0
ARG SRV_APT_GET_INSTALL=
ARG ENABLE_PG_TRICKLE=
ARG PGRDF_VERSION=0.6.40
ARG PGRDF_SHA256_AMD64=e78edf5bf41a4fa8e411c001a85de1ccc0b01a67cc2233f5e3a91a06091d787e
ARG PGRDF_SHA256_ARM64=b7dcd8e22680f009a7fcc94079f7eec3a2e58d85a4fff47eb178ed231006bffd
ENV SRV_UID=1000
ENV SRV_GID=100
ENV SRV_LOCALE=en_GB
ENV ENABLE_PG_TRICKLE=
ENV DEBIAN_FRONTEND=noninteractive
ENV PGDATA=/data
ENV POSTGRES_INITDB_ARGS=--locale=en_GB.UTF-8 --lc-ctype=en_GB.UTF-8 --lc-monetary=en_GB.UTF-8 --lc-numeric=en_GB.UTF-8 --lc-time=en_GB.UTF-8 --lc-collate=en_GB.UTF-8 --encoding=UTF8
LABEL org.opencontainers.image.version=0
RUN |9 SRV_UID=1000 SRV_GID=100 SRV_LOCALE=en_GB SRV_VERSION=0 SRV_APT_GET_INSTALL= ENABLE_PG_TRICKLE= PGRDF_VERSION=0.6.40 PGRDF_SHA256_AMD64=e78edf5bf41a4fa8e411c001a85de1ccc0b01a67cc2233f5e3a91a06091d787e PGRDF_SHA256_ARM64=b7dcd8e22680f009a7fcc94079f7eec3a2e58d85a4fff47eb178ed231006bffd /bin/sh -c if [ -z "$( getent group $SRV_GID )" ] ; then groupadd -r postgres --gid=$SRV_GID ; fi && useradd -r -g $SRV_GID --uid=$SRV_UID --home-dir=/var/lib/postgresql --shell=/bin/bash postgres && mkdir -p $PGDATA && chown -R $SRV_UID:$SRV_GID $PGDATA && apt-get update -y && apt-get install -y --no-install-recommends apt-utils && ( curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor > /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg ) && ( echo "deb http://apt.postgresql.org/pub/repos/apt $(. /etc/os-release && echo $VERSION_CODENAME)-pgdg main" > /etc/apt/sources.list.d/pgdg.list ) && apt-get update -y && apt-get upgrade -y && mkdir -p /docker-entrypoint-initdb.d && apt-get install -y --no-install-recommends postgresql-18 postgresql-common postgresql-18-cron postgresql-18-extra-window-functions postgresql-18-numeral postgresql-18-pgmemcache postgresql-18-pgpcre postgresql-18-postgis-3 postgresql-18-postgis-3-scripts postgresql-18-repack postgresql-18-set-user postgresql-18-similarity postgresql-18-age postgresql-18-pgvector postgresql-18-tablelog locales-all $SRV_APT_GET_INSTALL && apt-get clean && rm -rf ~/.cache && rm -rf /var/lib/apt/lists/* # buildkit
RUN |9 SRV_UID=1000 SRV_GID=100 SRV_LOCALE=en_GB SRV_VERSION=0 SRV_APT_GET_INSTALL= ENABLE_PG_TRICKLE= PGRDF_VERSION=0.6.40 PGRDF_SHA256_AMD64=e78edf5bf41a4fa8e411c001a85de1ccc0b01a67cc2233f5e3a91a06091d787e PGRDF_SHA256_ARM64=b7dcd8e22680f009a7fcc94079f7eec3a2e58d85a4fff47eb178ed231006bffd /bin/sh -c arch="$(dpkg --print-architecture)" && case "$arch" in amd64) sha="$PGRDF_SHA256_AMD64" ;; arm64) sha="$PGRDF_SHA256_ARM64" ;; *) echo "pgRDF: no prebuilt archive for $arch" >&2 ; exit 1 ;; esac && dir="pgrdf-${PGRDF_VERSION}-pg18-glibc-${arch}" && cd /tmp && curl -fsSL -o pgrdf.tar.gz "https://github.com/styk-tv/pgRDF/releases/download/v${PGRDF_VERSION}/${dir}.tar.gz" && echo "${sha} pgrdf.tar.gz" | sha256sum -c - && tar -xzf pgrdf.tar.gz && install -m 755 "$dir/lib/pgrdf.so" /usr/lib/postgresql/18/lib/ && install -m 644 "$dir"/share/extension/* /usr/share/postgresql/18/extension/ && rm -rf /tmp/pgrdf.tar.gz "/tmp/$dir" # buildkit
RUN |9 SRV_UID=1000 SRV_GID=100 SRV_LOCALE=en_GB SRV_VERSION=0 SRV_APT_GET_INSTALL= ENABLE_PG_TRICKLE= PGRDF_VERSION=0.6.40 PGRDF_SHA256_AMD64=e78edf5bf41a4fa8e411c001a85de1ccc0b01a67cc2233f5e3a91a06091d787e PGRDF_SHA256_ARM64=b7dcd8e22680f009a7fcc94079f7eec3a2e58d85a4fff47eb178ed231006bffd /bin/sh -c if [ "$ENABLE_PG_TRICKLE" = "true" ] ; then apt-get update -y && apt-get install -y --no-install-recommends postgresql-server-dev-18 && curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs | sh -s -- -y && export PATH="/root/.cargo/bin:$PATH" && cargo install --locked cargo-pgrx --version 0.18.0 && cargo pgrx init --pg18=/usr/lib/postgresql/18/bin/pg_config && git clone --branch v0.108.3 --depth 1 https://github.com/trickle-labs/pg-trickle.git /tmp/pg-trickle && cd /tmp/pg-trickle && cargo pgrx install --release --pg-config=/usr/lib/postgresql/18/bin/pg_config && rm -rf /root/.cargo /root/.rustup /root/.pgrx /tmp/pg-trickle && apt-get purge -y postgresql-server-dev-18 && apt-get autoremove -y && apt-get clean && rm -rf /var/lib/apt/lists/* ; fi # buildkit
ENV PATH=/usr/lib/postgresql/18/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
COPY docker-entrypoint.sh / # buildkit
USER 1000:100
RUN |9 SRV_UID=1000 SRV_GID=100 SRV_LOCALE=en_GB SRV_VERSION=0 SRV_APT_GET_INSTALL= ENABLE_PG_TRICKLE= PGRDF_VERSION=0.6.40 PGRDF_SHA256_AMD64=e78edf5bf41a4fa8e411c001a85de1ccc0b01a67cc2233f5e3a91a06091d787e PGRDF_SHA256_ARM64=b7dcd8e22680f009a7fcc94079f7eec3a2e58d85a4fff47eb178ed231006bffd /bin/sh -c ln -s $PGDATA/.bash_history $HOME/.bash_history # buildkit
WORKDIR /data
ENTRYPOINT ["/docker-entrypoint.sh"]
STOPSIGNAL SIGINT
EXPOSE map[5432/tcp:{}]
CMD ["postgres" "-c" "listen_addresses=*"]
HEALTHCHECK &{["CMD-SHELL" "pg_isready -U \"${POSTGRES_USER:-postgres}\""] "30s" "3s" "0s" "0s" '\x04'}

Labels

Key Value
org.opencontainers.image.revision 1719ec7075414dd4c4b7249db72abd2cfae05e38
org.opencontainers.image.source https://src.ci/srv/postgres
org.opencontainers.image.version 0
Details
Container
2026-11-11 02:30:24 +00:00
15
OCI / Docker
linux/amd64
543 MiB
Versions (4) View all
18.6 2026-11-11
18 2026-11-11
17 2025-06-04
latest 2024-12-15