Ryan Malloy
cd338c3c64
Replace the sat_code git submodule (lib/sat_code/) with vendored sources in src/sgp4/. The upstream .cpp files are renamed to .c — the code is valid C99 with zero C++ features. This eliminates the g++ and -lstdc++ build dependencies. Adds 518 Vallado test vectors (AIAA 2006-6753-Rev1) as a 13th regression suite to verify byte-identical numerical output. Updates all documentation (CLAUDE.md, DESIGN.md, 11 MDX pages, Dockerfile) to reflect the new layout and pure-C compilation.
76 lines
3.1 KiB
Docker
76 lines
3.1 KiB
Docker
ARG PG_MAJOR=17
|
|
|
|
# ── Stage 1: Compile against PostgreSQL on Ubuntu 22.04 ─────
|
|
# Ubuntu Jammy matches TimescaleDB-HA's glibc (2.35).
|
|
# Building on Debian Bookworm (glibc 2.36) risks symbol version
|
|
# mismatches when the .so loads in TimescaleDB's runtime.
|
|
FROM ubuntu:22.04 AS builder
|
|
|
|
ARG PG_MAJOR
|
|
ARG DEBIAN_FRONTEND=noninteractive
|
|
|
|
# PGDG apt repository (same source TimescaleDB-HA uses)
|
|
RUN apt-get update && apt-get install -y --no-install-recommends \
|
|
ca-certificates curl gnupg lsb-release && \
|
|
curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc \
|
|
| gpg --dearmor -o /usr/share/keyrings/postgresql.gpg && \
|
|
echo "deb [signed-by=/usr/share/keyrings/postgresql.gpg] \
|
|
http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" \
|
|
> /etc/apt/sources.list.d/pgdg.list && \
|
|
apt-get update && apt-get install -y --no-install-recommends \
|
|
postgresql-${PG_MAJOR} \
|
|
postgresql-server-dev-${PG_MAJOR} \
|
|
gcc make && \
|
|
rm -rf /var/lib/apt/lists/*
|
|
|
|
# Copy source tree (submodule content included as regular files)
|
|
WORKDIR /build/pg_orbit
|
|
COPY . .
|
|
|
|
ENV PG_CONFIG=/usr/lib/postgresql/${PG_MAJOR}/bin/pg_config
|
|
|
|
# Build extension
|
|
RUN make PG_CONFIG=${PG_CONFIG}
|
|
|
|
# Install to system location (needed for installcheck)
|
|
RUN make PG_CONFIG=${PG_CONFIG} install
|
|
|
|
# Run all 13 regression test suites against a throwaway cluster
|
|
RUN su postgres -c "/usr/lib/postgresql/${PG_MAJOR}/bin/initdb -D /tmp/pgtest" && \
|
|
su postgres -c "/usr/lib/postgresql/${PG_MAJOR}/bin/pg_ctl -D /tmp/pgtest -l /tmp/pgtest.log start" && \
|
|
su postgres -c "/usr/lib/postgresql/${PG_MAJOR}/bin/createuser -s root" && \
|
|
make PG_CONFIG=${PG_CONFIG} installcheck && \
|
|
su postgres -c "/usr/lib/postgresql/${PG_MAJOR}/bin/pg_ctl -D /tmp/pgtest stop"
|
|
|
|
# Capture artifacts under /pg_orbit prefix for the next stage
|
|
RUN make PG_CONFIG=${PG_CONFIG} DESTDIR=/pg_orbit install
|
|
|
|
|
|
# ── Stage 2: Minimal artifact (COPY --from target) ──────────
|
|
# ~525 KB total: .so + .control + .sql + init script.
|
|
# Downstream images (TimescaleDB-HA, vanilla PG) pull from here.
|
|
FROM scratch AS artifact
|
|
|
|
COPY --from=builder /pg_orbit/ /
|
|
COPY docker/020_install_pg_orbit.sh /docker-entrypoint-initdb.d/
|
|
|
|
|
|
# ── Stage 3: Standalone dev/test image ───────────────────────
|
|
# Ready-to-run PostgreSQL with pg_orbit pre-installed.
|
|
# For development, CI, and standalone experiments.
|
|
#
|
|
# Optional DE ephemeris at runtime (recommended):
|
|
# docker run -v /path/to/de440.bin:/var/lib/postgresql/pg_orbit/de440.bin pg_orbit
|
|
# Then: ALTER SYSTEM SET pg_orbit.ephemeris_path = '/var/lib/postgresql/pg_orbit/de440.bin';
|
|
#
|
|
# Or bake into the image (115 MB for DE440, 3.1 GB for DE441):
|
|
# Place the DE file in the build context, then:
|
|
# docker build --build-arg DE_FILE=de440.bin -t pg_orbit:de440 .
|
|
FROM postgres:${PG_MAJOR}-bookworm AS standalone
|
|
|
|
COPY --from=artifact / /
|
|
|
|
# Create the pg_orbit data directory for DE ephemeris files
|
|
RUN mkdir -p /var/lib/postgresql/pg_orbit && \
|
|
chown postgres:postgres /var/lib/postgresql/pg_orbit
|