An example Dockerfile for PostgreSQL that uses Alpine as the base image. It employs a multi-stage build to re-build gosu with a newer Go version and also includes additional PostgreSQL extensions.

postgres.Dockerfile

# Common arguments
ARG PG_EXTENSION_DIR=/usr/local/share/postgresql/extension
ARG PG_LIB_DIR=/usr/local/lib/postgresql
ARG GO_BIN_PATH=/go/bin

# STAGE: build 'gosu' with latest golang version
# This will get rid of all false positive CVE alerts related to golang 1.18,
# see https://github.com/tianon/gosu/security
FROM library/golang:alpine3.20 AS build-gosu
RUN go install github.com/tianon/gosu@latest

# STAGE: base image for postgresql
FROM library/postgres:15-alpine3.20 AS base-postgres-image
ARG GO_BIN_PATH
COPY --from=build-gosu $GO_BIN_PATH/gosu /usr/local/bin/gosu

# STAGE: build 'pgsodium' extension
FROM base-postgres-image AS build-pgsodium
RUN apk add \
  --no-cache \
  git make libc-dev clang15 llvm15-dev libsodium-dev
RUN mkdir -p /src \
  && git clone https://github.com/michelp/pgsodium.git /src/pgsodium \
  && cd /src/pgsodium \
  && make install

# STAGE: final image
FROM base-postgres-image AS final-image
ARG PG_EXTENSION_DIR
ARG PG_LIB_DIR
COPY --from=build-pgsodium $PG_EXTENSION_DIR $PG_EXTENSION_DIR
COPY --from=build-pgsodium $PG_LIB_DIR $PG_LIB_DIR
RUN apk add \
  --no-cache \
  libsodium