#619 The PostgreSQL job runs in a prebuilt image on the project's runner (#605)
–
- github
- github/openchronology/timeline-app
- github/openchronology/timeline-app#619
- pull request
- state:merged
The third image from #605: **PostgreSQL 16 with pgmp and the native build dependencies**. - **Image** (`deploy/postgres-ci`): PostgreSQL 16 with pgmp, GMP, SQLite, the compilers, CMake, Python and Rust 1.99.0. It's built on the same Playwright image the browser jobs use, so the browsers and their system packages are already in it. `och-ci-postgres` starts a disposable test database with pgmp, either in the background (CI) or until stopped with `--foreground`, which also gives a local test database. - **Publishing:** `scripts/build-images.mjs` tags the image with a hash of its Dockerfile and start script. `build-images.yml` builds, pushes and attests it alongside the desktop build image. - **In CI:** - The PostgreSQL job runs in the image, so it no longer runs apt, builds pgmp or uses `sudo`. - It moves to the `och-heavy` runner; pull requests from forks still use GitHub's runners. - A new `postgres-image` job finds the published image, or builds and pushes it when a branch changes it. - OpenLDAP runs as a service container, so the job never touches the runner's Docker. - **Journald:** following the systemd journal needs the host's journal and `sudo`, so it moves to its own small job on GitHub's runner, against the image's database. - **Tests:** `test/build-images.test.mjs` checks the image's tag, that its base matches the browser jobs' Playwright image, and the job wiring. - **Docs:** `deploy/postgres-ci/README.md`, `docs/development.md` (the project runner) and the folder READMEs. Closes #605. 🤖 Generated with [Claude Code](https://claude.com/claude-code) https://claude.ai/code/session_011fFY8eruEi1xAkkMBni13B https://github.com/circagraph/timeline-app/pull/619
Related
Open #619 The PostgreSQL job runs in a prebuilt image on the project's runner (#605) in the timeline