Support using the client's OS trusted CA.
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
Security
Description
Specifying sslroot=system instructs PostgreSQL to use the trusted certificate authority (CA) store provided by the client's operating system.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 415
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "support-using-the-clients-os-trusted-ca",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Support using the client's OS trusted CA.",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Support using the client's OS trusted CA.",
"NameLocale": "en",
"GroupKey": "security",
"GroupName": "Security",
"GroupLocale": "en",
"Ordinal": 31,
"GroupOrder": 14,
"Facts": {
"feature": {
"description": "Specifying `sslroot=system` instructs PostgreSQL to use the trusted certificate authority (CA) store provided by the client's operating system.",
"name": "Support using the client's OS trusted CA.",
"versions": {
"16": "Yes"
}
},
"group": "Security",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "11",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "12",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "13",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "15",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
}
],
"Texts": [
{
"Locale": "en",
"Title": "Support using the client's OS trusted CA.",
"BodyHTML": "\u003cp\u003eSpecifying \u003ccode\u003esslroot=system\u003c/code\u003e instructs PostgreSQL to use the trusted certificate authority (CA) store provided by the client\u0026#39;s operating system.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "719329cfcc8088141b003b797fbaa3c94081f3f075f59bbaec4800049499e7c3",
"Payload": {
"description": "Specifying `sslroot=system` instructs PostgreSQL to use the trusted certificate authority (CA) store provided by the client's operating system.",
"name": "Support using the client's OS trusted CA.",
"versions": {
"16": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "支持使用客户端操作系统的受信任 CA",
"BodyHTML": "\u003cp\u003e将 \u003ccode\u003esslrootcert\u003c/code\u003e 设为 \u003ccode\u003esystem\u003c/code\u003e 后，PostgreSQL 将使用客户端操作系统提供的受信任 CA 证书库。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "098a662db17d8f8b47bcefa60cccaafb1bcd6cb990869c6d4386db257978f1d2",
"Payload": {
"description": "将 `sslrootcert` 设为 `system` 后，PostgreSQL 将使用客户端操作系统提供的受信任 CA 证书库。",
"name": "支持使用客户端操作系统的受信任 CA"
}
}
],
"GroupTitles": {
"en": "Security",
"zh-Hans": "安全"
},
"LegacyIDs": [
"415"
]
}