{"schemaVersion":1,"id":"postgresql","revision":"2026-09-14.1","name":"PostgreSQL","monogram":"P","category":"Engine","openness":"Open source","license":"PostgreSQL License","color":"#64cdb5","summary":"Relational SQL engine with JSON types and extensibility.","website":"https://www.postgresql.org/about/","repository":"","environment":"Self-managed","contributor":"Testedknowhow database research","affiliation":"Commissioned by a Nimbalyst maintainer. Documentation synthesis; no independent review or product execution.","contentLicense":"Unlicensed prototype; redistribution decision pending","reviewStatus":"unreviewed","lastChecked":"2026-09-14","expiresAt":"2026-10-14","applicability":{"versions":["Unpinned upstream documentation accessed 2026-09-14; pin engine, extension and service versions before use."],"environment":"Operator manages deployment, backups and upgrades. This target excludes extensions.","excludes":["Runtime verification","Workload benchmarks and cost comparisons","Unlisted extensions, service tiers and deployment configurations"]},"database":{"models":["Relational"],"deployment":"Self-managed","kind":"Engine","components":[],"boundary":"Operator manages deployment, backups and upgrades. This target excludes extensions.","evidenceIds":["postgresql-s0","postgresql-s1"]},"claims":[{"id":"postgresql-db-sql","capability":"db-sql","statement":"Queries relational tables using SQL.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["postgresql-s0"],"contradictions":[],"support":"yes"},{"id":"postgresql-db-json","capability":"db-json","statement":"Supports JSON and JSONB values.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["postgresql-s0"],"contradictions":[],"support":"yes"},{"id":"postgresql-db-transactions","capability":"db-transactions","statement":"Supports transactions and isolation levels including Serializable.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["postgresql-s0"],"contradictions":[],"support":"yes"},{"id":"postgresql-db-replication","capability":"db-replication","statement":"Supports synchronous, asynchronous and logical replication.","method":"documented","outcome":"claimed","scope":"Documented for this target; no runtime tests recorded.","evidenceIds":["postgresql-s0"],"contradictions":[],"support":"yes"},{"id":"postgresql-db-pitr","capability":"db-pitr","statement":"Supports WAL-based point-in-time recovery.","method":"documented","outcome":"claimed","scope":"Operator must configure recovery and retain the required WAL and backups.","evidenceIds":["postgresql-s0"],"contradictions":[],"support":"yes"}],"evidence":[{"id":"postgresql-s0","url":"https://www.postgresql.org/about/","title":"PostgreSQL overview","locator":"Data types; transactions; recovery; security","capturedAt":"2026-09-14","kind":"vendor-documentation","revision":null,"redistribution":"Link and original paraphrase only; upstream rights retained."},{"id":"postgresql-s1","url":"https://www.postgresql.org/about/licence/","title":"PostgreSQL license","locator":"PostgreSQL License","capturedAt":"2026-09-14","kind":"vendor-documentation","revision":null,"redistribution":"Link and original paraphrase only; upstream rights retained."}],"gaps":["Which pinned versions, topology and service tier fit the intended workload?","What are measured correctness, latency, recovery and total operating cost under that workload?"],"invalidationTriggers":["Upstream version, license, API, service plan or storage topology changes."],"verificationPlan":["Pin the target configuration and define workload fixtures, access and budget.","With authorization, test concurrent writes and recovery against explicit correctness expectations.","For vector workloads, measure filtered recall against an exact-search baseline and record index settings."],"attestations":[]}