pre-build cargo pgrx

pgrx.Dockerfile

# CNPG only support Debian 12 (Bookworm)
FROM ubuntu:22.04

ARG PGRX_VERSION=0.12.8
ARG SCCACHE_VERSION=0.8.2

ENV DEBIAN_FRONTEND=noninteractive \
    LANG=en_US.UTF-8 \
    LC_ALL=en_US.UTF-8 \
    RUSTFLAGS="-Dwarnings" \
    RUST_BACKTRACE=1 \
    CARGO_TERM_COLOR=always

RUN set -eux; \
    apt update; \
    apt install -y --no-install-recommends \
        curl \
        ca-certificates \
        build-essential \
        postgresql-common gnupg \
        crossbuild-essential-arm64 \
        qemu-user-static \
        libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt-dev libssl-dev libxml2-utils xsltproc ccache pkg-config \
        clang

# set up sccache
RUN set -ex; \
    curl -fsSL -o sccache.tar.gz https://github.com/mozilla/sccache/releases/download/v${SCCACHE_VERSION}/sccache-v${SCCACHE_VERSION}-x86_64-unknown-linux-musl.tar.gz; \
    tar -xzf sccache.tar.gz --strip-components=1; \
    rm sccache.tar.gz; \
    mv sccache /usr/local/bin/

RUN /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh -y
# install all the PostgresQL
RUN set -ex; \
    for v in $(seq 14 17); do \
        apt install -y --no-install-recommends postgresql-$v postgresql-server-dev-$v postgresql-$v-pgvector; \
    done; \
    rm -rf /var/lib/apt/lists/*;

# create a non-root user (make it compatible with Ubuntu 24.04)
RUN useradd -u 1000 -U -m ubuntu
RUN chown -R ubuntu:ubuntu /usr/share/postgresql/ /usr/lib/postgresql/
USER ubuntu
ENV PATH="$PATH:/home/ubuntu/.cargo/bin"
RUN curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs | sh -s -- --default-toolchain=none -y

WORKDIR /workspace
COPY rust-toolchain.toml /workspace/rust-toolchain.toml
# ref: https://github.com/pgcentralfoundation/pgrx/blob/develop/docs/src/extension/build/cross-compile.md
RUN set -ex; \
    echo 'target.aarch64-unknown-linux-gnu.linker = "aarch64-linux-gnu-gcc"' >> ~/.cargo/config.toml; \
    echo 'target.aarch64-unknown-linux-gnu.runner = ["qemu-aarch64-static", "-L", "/usr/aarch64-linux-gnu"]' >> ~/.cargo/config.toml
RUN rustup target add x86_64-unknown-linux-gnu aarch64-unknown-linux-gnu

RUN cargo install cargo-pgrx --locked --version=${PGRX_VERSION}

RUN set -ex; \
    for v in $(seq 14 17); do \
        cargo pgrx init --pg$v=/usr/lib/postgresql/$v/bin/pg_config; \
    done;

ENTRYPOINT [ "cargo" ]

usage.md

Build

docker build -t pgrx:0.12.8 -f pgrx.Dockerfile .

Run

docker run --rm -v .:/workspace pgrx:0.12.8 clippy --target aarch64-unknown-linux-gnu --features pg17 -- -D warnings
docker run --rm -v .:/workspace pgrx:0.12.8 test --no-fail-fast --target aarch64-unknown-linux-gnu --features pg17
docker run --rm -v .:/workspace pgrx:0.12.8 build --lib --target aarch64-unknown-linux-gnu --features pg17