# Builds PostgreSQL from a local source checkout, inside the container only.
FROM debian:bookworm-slim
RUN apt-get update && apt-get install -y --no-install-recommends build-essential bison flex pkg-config libreadline-dev zlib1g-dev ca-certificates && rm -rf /var/lib/apt/lists/*
COPY src-REL_19_STABLE /src
WORKDIR /src
RUN ./configure --prefix=/usr/local/pgsql --without-icu CFLAGS=-O2 >/dev/null && make -s -j12 && make -s install && make -s -C contrib/pgbench install 2>/dev/null || true
RUN useradd -m postgres && mkdir /data && chown postgres /data
ENV PATH=/usr/local/pgsql/bin:$PATH
USER postgres
CMD ["bash","-c","initdb -D /data >/dev/null && echo \"listen_addresses='*'\" >> /data/postgresql.conf && echo 'host all all all trust' >> /data/pg_hba.conf && exec postgres -D /data"]