Schedule - PostgreSQL Development Conference 2025

Reproducible Postgres

Date: 2025-05-14
Time: 17:00–17:25
Room: Breakout Room 2
Level: Beginner

Reproducible Postgres is an Apache-licensed, secure Postgres distribution that packages vanilla upstream PostgreSQL. It’s built under the guiding principles of reproducible and hermetic builds. These principles aim to guarantee that you will get exactly the same Postgres binaries ("bit-by-bit") whenever and wherever you build them, and that no build artifact is tainted by the host environment where it’s built.

Among other benefits, this means that all artifacts are content-addressable; that they provide a strong defense against supply-chain attacks; and that build and caching efficiencies are really high.

The speakers will dive into the journey towards creating Reproducible Postgres, including, among others:

  • What are reproducible and hermetic builds and their benefits.
  • Which are the best tools to produce such builds.
  • Why the project settled on Bazel, and what are the technical challenges faced.
  • How to build Postgres and the extensions ecosystem from a single “monorepo”.
  • Notes on toolchains, cross-compilation, buildfarms and build outputs.
  • What, if anything, could the current Postgres build system learn from this experience.

Speaker

Alvaro Hernandez
Javier Maestro