{"kind": "role", "major": "18", "item": {"slug": "pg_read_all_settings", "name": "pg_read_all_settings", "name_zh": "pg_read_all_settings", "category": "Monitoring and statistics", "summary": "pg_read_all_settings allows reading all configuration variables, even those normally visible only to superusers.", "aliases": [], "versions": {"10": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Default roles"}], "related": [], "release": {"ref": "PostgreSQL 10.23 Documentation", "label": "10.23", "major": "10", "channel": "historical", "revision": "81531820e09c1192eff515d27cafa3e7845d8b991b1e3042527938519ba67b28"}, "sources": [{"url": "/docs/10/default-roles.html#DEFAULT-ROLES-TABLE", "label": "PostgreSQL 10.23 Documentation", "sha256": "81531820e09c1192eff515d27cafa3e7845d8b991b1e3042527938519ba67b28"}, {"url": "https://www.postgresql.org/docs/10/default-roles.html#DEFAULT-ROLES-TABLE", "label": "PostgreSQL 10 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_monitor , pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics and other system information normally restricted to superusers."]}], "description": ["Read all configuration variables, even those normally visible only to superusers."]}, "11": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Default roles"}], "related": [], "release": {"ref": "PostgreSQL 11.22 Documentation", "label": "11.22", "major": "11", "channel": "historical", "revision": "13adc471db2c3719b872a5ccb9c6cb6a7dad2f2c080f8fe6cc5374c8d6828099"}, "sources": [{"url": "/docs/11/default-roles.html#DEFAULT-ROLES-TABLE", "label": "PostgreSQL 11.22 Documentation", "sha256": "13adc471db2c3719b872a5ccb9c6cb6a7dad2f2c080f8fe6cc5374c8d6828099"}, {"url": "https://www.postgresql.org/docs/11/default-roles.html#DEFAULT-ROLES-TABLE", "label": "PostgreSQL 11 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_monitor , pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics and other system information normally restricted to superusers."]}], "description": ["Read all configuration variables, even those normally visible only to superusers."]}, "12": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Default roles"}], "related": [], "release": {"ref": "PostgreSQL 12.22 Documentation", "label": "12.22", "major": "12", "channel": "historical", "revision": "993243a8e1f0496fe066e6ed6e39d0d04b3aa25115e168609a38316b7110bdad"}, "sources": [{"url": "/docs/12/default-roles.html#DEFAULT-ROLES-TABLE", "label": "PostgreSQL 12.22 Documentation", "sha256": "993243a8e1f0496fe066e6ed6e39d0d04b3aa25115e168609a38316b7110bdad"}, {"url": "https://www.postgresql.org/docs/12/default-roles.html#DEFAULT-ROLES-TABLE", "label": "PostgreSQL 12 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_monitor , pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics and other system information normally restricted to superusers."]}], "description": ["Read all configuration variables, even those normally visible only to superusers."]}, "13": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Default roles"}], "related": [], "release": {"ref": "PostgreSQL 13.23 Documentation", "label": "13.23", "major": "13", "channel": "historical", "revision": "fef5a8f24a15034fbb3fa45d81971d5d77ff79f2725386ec3d3c476fae935dd3"}, "sources": [{"url": "/docs/13/default-roles.html#DEFAULT-ROLES-TABLE", "label": "PostgreSQL 13.23 Documentation", "sha256": "fef5a8f24a15034fbb3fa45d81971d5d77ff79f2725386ec3d3c476fae935dd3"}, {"url": "https://www.postgresql.org/docs/13/default-roles.html#DEFAULT-ROLES-TABLE", "label": "PostgreSQL 13 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_monitor , pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics and other system information normally restricted to superusers."]}], "description": ["Read all configuration variables, even those normally visible only to superusers."]}, "14": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 14.24 Documentation", "label": "14.24", "major": "14", "channel": "stable", "revision": "c4f98c255865a7a07ab35932e3b23ce2ab575a70c0cd8d3194de646732680f44"}, "sources": [{"url": "/docs/14/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 14.24 Documentation", "sha256": "c4f98c255865a7a07ab35932e3b23ce2ab575a70c0cd8d3194de646732680f44"}, {"url": "https://www.postgresql.org/docs/14/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 14 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_monitor , pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics and other system information normally restricted to superusers."]}], "description": ["Read all configuration variables, even those normally visible only to superusers."]}, "15": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 15.19 Documentation", "label": "15.19", "major": "15", "channel": "stable", "revision": "043d217ec318b20df8710081386db7be2eacafc839eae7f0c12df2712955f55a"}, "sources": [{"url": "/docs/15/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 15.19 Documentation", "sha256": "043d217ec318b20df8710081386db7be2eacafc839eae7f0c12df2712955f55a"}, {"url": "https://www.postgresql.org/docs/15/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 15 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_monitor , pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics and other system information normally restricted to superusers."]}], "description": ["Read all configuration variables, even those normally visible only to superusers."]}, "16": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 16.15 Documentation", "label": "16.15", "major": "16", "channel": "stable", "revision": "8626abe19619170614b1adbddcf8a8b5c58983fa82b372312ed7da04b73593ea"}, "sources": [{"url": "/docs/16/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 16.15 Documentation", "sha256": "8626abe19619170614b1adbddcf8a8b5c58983fa82b372312ed7da04b73593ea"}, {"url": "https://www.postgresql.org/docs/16/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 16 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_monitor , pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics and other system information normally restricted to superusers."]}], "description": ["Read all configuration variables, even those normally visible only to superusers."]}, "17": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 17.11 Documentation", "label": "17.11", "major": "17", "channel": "stable", "revision": "64c01b6876124ed9b6190d7418108b81e2f35b6290b0562b8e4466a65e0eb603"}, "sources": [{"url": "/docs/17/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 17.11 Documentation", "sha256": "64c01b6876124ed9b6190d7418108b81e2f35b6290b0562b8e4466a65e0eb603"}, {"url": "https://www.postgresql.org/docs/17/predefined-roles.html#PREDEFINED-ROLES-TABLE", "label": "PostgreSQL 17 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["The pg_monitor , pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics and other system information normally restricted to superusers."]}], "description": ["Read all configuration variables, even those normally visible only to superusers."]}, "18": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 18.6 Documentation", "label": "18.6", "major": "18", "channel": "stable", "revision": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, "sources": [{"url": "/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR", "label": "PostgreSQL 18 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics, and other system information normally restricted to superusers."]}], "description": ["pg_read_all_settings allows reading all configuration variables, even those normally visible only to superusers."]}, "19": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, "sources": [{"url": "/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR", "label": "PostgreSQL 19 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics, and other system information normally restricted to superusers."]}], "description": ["pg_read_all_settings allows reading all configuration variables, even those normally visible only to superusers."]}, "20": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, "sources": [{"url": "/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR", "label": "PostgreSQL devel online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics, and other system information normally restricted to superusers."]}], "description": ["pg_read_all_settings allows reading all configuration variables, even those normally visible only to superusers."]}}, "content_hash": "f0ed5964a1896981914057287567e0868e02e6574ac5307ffc7112478f5490a0", "imported_at": "2026-09-27T09:57:59.055"}, "snapshot": {"facts": [{"label": "Name", "value": "pg_read_all_settings"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [], "release": {"ref": "PostgreSQL 18.6 Documentation", "label": "18.6", "major": "18", "channel": "stable", "revision": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, "sources": [{"url": "/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR", "label": "PostgreSQL 18 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics, and other system information normally restricted to superusers."]}], "description": ["pg_read_all_settings allows reading all configuration variables, even those normally visible only to superusers."]}, "comparison": {"left": "13", "right": "14", "status": "changed", "diff": "--- PostgreSQL 13\n+++ PostgreSQL 14\n@@ -6,7 +6,7 @@\n     },\n     {\n       \"label\": \"Manual terminology\",\n-      \"value\": \"Default roles\"\n+      \"value\": \"Predefined roles\"\n     }\n   ],\n   \"signature\": null,"}}