PostgreSQL
Open-source relational database server with built-in streaming replication and hot standby.
| ID | postgresql |
| Layer | state |
| Version | 18.7 |
| Tiers | T1, T2, T3 |
| Requires | nothing |
| License | PostgreSQL License |
| Evidence | docs |
| Last verified | 2026-11-22 |
Choose it when
Section titled “Choose it when”- A relational SQL database with built-in streaming replication and read-only hot standby servers is needed.
Avoid it when
Section titled “Avoid it when”- Automatic failure detection and failover are required but no separate cluster-management tooling will be built or carried into the isolated network.
Caveats
Section titled “Caveats”- High availability (needed for the T3 default ‘highly available’): built in are WAL streaming replication (asynchronous by default), synchronous replication, hot standby servers that accept read-only queries, and promotion of a standby with pg_ctl promote or pg_promote(). Not built in: the documentation states ‘PostgreSQL does not provide the system software required to identify a failure on the primary and notify the standby database server’, and a mechanism to tell a restarted old primary that it is no longer primary (STONITH) is also required. Failure detection, automatic promotion and fencing need additional tooling that this entry does not list; add it to the design and to the transfer manifest.
- With asynchronous streaming replication, committed transactions may not have reached the standby when the primary crashes, and the data loss is proportional to the replication delay; synchronous replication confirms that changes reached one or more synchronous standbys.
- Image layout change: since PostgreSQL 18 the image’s PGDATA is /var/lib/postgresql/<major version>/docker and its volume is /var/lib/postgresql; images for PostgreSQL 17 and below keep the data volume at /var/lib/postgresql/data.
- The license is the PostgreSQL License, described by the project as a liberal open-source license similar to BSD or MIT. The container image also holds other software (base distribution and dependencies) under other licenses.
Carrying it in
Section titled “Carrying it in”| Image | Hardware | Digest |
|---|---|---|
postgres:18.7 |
any | not pinned |
License server
Section titled “License server”No license server is contacted.
No telemetry documentation found on 2026-11-21; vet before adoption. A search of the PostgreSQL documentation site for ‘telemetry’ and for ‘air-gap’ returned no hits, and no document describes an update check or phone-home feature. Nothing is documented that the server downloads while it runs. The image postgres:18.7 is the Docker Official Image on Docker Hub (short name for docker.io/library/postgres); it is maintained by ‘the PostgreSQL Docker Community’ (github.com/docker-library/postgres), not by the PostgreSQL Global Development Group. Other tags of the same release exist (for example 18.7-trixie, 18.7-bookworm, 18.7-alpine); the entry lists the plain tag. Since PostgreSQL 18 the image’s PGDATA is version specific and its volume is /var/lib/postgresql (see caveats). Source tarballs and OS packages are on https://www.postgresql.org/download/ for installs without the image.
Evidence
Section titled “Evidence”All values were read from the pages in sources on 2026-11-21, and the version, the image tag and the documentation links were re-checked on 2026-11-22, as were the PostgreSQL versions that the kong, harbor, k3s and litellm entries cite (the four pinned pages added to sources on that date). The postgres/postgres repository publishes no GitHub releases, so the version comes from the project’s versioning page. The newest major version is 19 (19.0, released 2026-11-19, https://www.postgresql.org/docs/release/19.0/), but the catalog pins the latest release of the previous major version, 18.7 (released 2026-11-12, https://www.postgresql.org/docs/release/18.7/; 18 is supported until 2030-11-14 per the versioning page), because Keycloak, which lists this component in requires, supports PostgreSQL 14.x to 18.x only and calls any other version not a supported configuration (https://www.keycloak.org/server/db). No other entry states an upper limit that 18.7 exceeds: litellm, the other entry that requires this component, states no supported version (its quickstart compose file at tag v1.110.2 runs postgres:16); kong and harbor, which can use PostgreSQL without requiring it, state lower limits that 18.7 meets (kong.conf.default at tag 3.9.5: ‘Kong supports PostgreSQL versions 9.5 and above’; Harbor’s Helm high-availability page: ‘Highly available PostgreSQL 9.6+’); k3s, whose external datastore is optional, lists the PostgreSQL versions it is certified against, 15.12, 16.7 and 17.3, so a K3s datastore on 18.7 is outside that list; grafana and open-webui, which can use PostgreSQL, state no version. The tag 18.7 exists on Docker Hub (checked 2026-11-22). The documentation links are the /docs/18/ pages, and the statements in this entry were checked against them on 2026-11-22. The GitHub license API returns NOASSERTION; the license name is the one the project gives on its licence page. The PostgreSQL documentation does not point to a container image; the project wiki lists the Docker Hub image under the provider ‘the PostgreSQL Docker Community’.
Sources:
- https://www.postgresql.org/support/versioning/
- https://www.postgresql.org/about/licence/
- https://github.com/postgres/postgres/blob/master/COPYRIGHT
- https://wiki.postgresql.org/wiki/Ecosystem:Cloud_infrastructure
- https://hub.docker.com/_/postgres
- https://hub.docker.com/v2/repositories/library/postgres/tags/18.7
- https://www.postgresql.org/docs/release/18.7/
- https://www.postgresql.org/docs/release/19.0/
- https://www.keycloak.org/server/db
- https://github.com/Kong/kong/blob/3.9.5/kong.conf.default
- https://github.com/goharbor/website/blob/1ce1ac23f8d4969ce587b7ced8afb7954f76115d/docs/install-config/harbor-ha-helm.md
- https://github.com/k3s-io/docs/blob/8b33d6f4106826376a9784bc21d0fbba8dccbc69/docs/datastore/datastore.md
- https://github.com/BerriAI/litellm/blob/v1.110.2/docker/docker-compose.quickstart.yml
- https://github.com/docker-library/docs/blob/master/postgres/README.md
- https://github.com/docker-library/official-images/blob/master/library/postgres
- https://www.postgresql.org/docs/18/high-availability.html
- https://www.postgresql.org/docs/18/warm-standby.html
- https://www.postgresql.org/docs/18/warm-standby-failover.html
- https://www.postgresql.org/docs/18/hot-standby.html
- https://www.postgresql.org/search/?q=telemetry
- https://www.postgresql.org/search/?q=air-gap
Source of this page: skills/airgap-architect/catalog/components/postgresql.toml.