Skip to content

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
  • A relational SQL database with built-in streaming replication and read-only hot standby servers is needed.
  • Automatic failure detection and failover are required but no separate cluster-management tooling will be built or carried into the isolated network.
  • 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.
Image Hardware Digest
postgres:18.7 any not pinned

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.

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:

Source of this page: skills/airgap-architect/catalog/components/postgresql.toml.