pgfdb/Dockerfile at main · fabianlindfors/pgfdb · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
# Build stage
FROM postgres:17 AS builder

# Install build dependencies,  including Postgres server package to get header files in `/usr/include/postgresql`
RUN apt-get update && apt-get install -y \
    build-essential \
    curl \
    pkg-config \
    libssl-dev \
    libreadline-dev \
    zlib1g-dev \
    gnupg \
    lsb-release \
    libclang-dev \
    clang \
    postgresql-server-dev-17 \
    && rm -rf /var/lib/apt/lists/*

# Install FoundationDB client
# Detect architecture and download the appropriate package
RUN arch=$(dpkg --print-architecture) && \
    VERSION="7.3.63" && \
    if [ "$arch" = "amd64" ]; then \
        curl -LO "https://github.com/apple/foundationdb/releases/download/${VERSION}/foundationdb-clients_${VERSION}-1_amd64.deb" && \
        dpkg -i "foundationdb-clients_${VERSION}-1_amd64.deb" && \
        rm "foundationdb-clients_${VERSION}-1_amd64.deb"; \
    elif [ "$arch" = "arm64" ]; then \
        curl -LO "https://github.com/apple/foundationdb/releases/download/${VERSION}/foundationdb-clients_${VERSION}-1_aarch64.deb" && \
        dpkg -i "foundationdb-clients_${VERSION}-1_aarch64.deb" && \
        rm "foundationdb-clients_${VERSION}-1_aarch64.deb"; \
    else \
        echo "Unsupported architecture: $arch" && \
        exit 1; \
    fi

# Install Rust
RUN curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs | sh -s -- -y
ENV PATH="/root/.cargo/bin:${PATH}"

# Install cargo-pgrx and initialize it
RUN cargo install --version 0.14.1 --locked cargo-pgrx && \
    mkdir -p /root/.pgrx && \
    cargo pgrx init --pg17 /usr/lib/postgresql/17/bin/pg_config

# Copy the extension source code
WORKDIR /usr/src/pgfdb
COPY . .

# Build and package the extension
RUN cargo pgrx package --pg-config /usr/lib/postgresql/17/bin/pg_config

# Final stage
FROM postgres:17

# Install FoundationDB client (needed at runtime)
RUN apt-get update && apt-get install -y \
    curl \
    libssl3 \
    ca-certificates \
    libc6 \
    && rm -rf /var/lib/apt/lists/*

# Detect architecture and download the appropriate package
RUN arch=$(dpkg --print-architecture) && \
    VERSION="7.3.63" && \
    if [ "$arch" = "amd64" ]; then \
        curl -LO "https://github.com/apple/foundationdb/releases/download/${VERSION}/foundationdb-clients_${VERSION}-1_amd64.deb" && \
        dpkg -i "foundationdb-clients_${VERSION}-1_amd64.deb" && \
        rm "foundationdb-clients_${VERSION}-1_amd64.deb"; \
    elif [ "$arch" = "arm64" ]; then \
        curl -LO "https://github.com/apple/foundationdb/releases/download/${VERSION}/foundationdb-clients_${VERSION}-1_aarch64.deb" && \
        dpkg -i "foundationdb-clients_${VERSION}-1_aarch64.deb" && \
        rm "foundationdb-clients_${VERSION}-1_aarch64.deb"; \
    else \
        echo "Unsupported architecture: $arch" && \
        exit 1; \
    fi

# Copy only the built extension files from the builder stage
COPY --from=builder /usr/src/pgfdb/target/release/pgfdb-pg17/usr/lib/postgresql/17/lib/* /usr/lib/postgresql/17/lib/
COPY --from=builder /usr/src/pgfdb/target/release/pgfdb-pg17/usr/share/postgresql/17/extension/* /usr/share/postgresql/17/extension/

# Add a script to create and initialise the extension on database startup
RUN echo "CREATE EXTENSION pgfdb; ALTER SYSTEM SET default_table_access_method = pgfdb_table;" \
    > /docker-entrypoint-initdb.d/create_extension.sql

# Clear out the default data written by Postgres so that a fresh database is created when the container starts
RUN rm -rf /var/lib/postgresql/data

# Expose the PostgreSQL port
EXPOSE 5432

# The official postgres image already has a proper entrypoint