{"kind": "role", "major": "18", "rows": [{"slug": "pg_create_subscription", "name": "pg_create_subscription", "name_zh": "pg_create_subscription", "category": "Administration", "summary": "pg_create_subscription allows users with CREATE permission on the database to issue CREATE SUBSCRIPTION .", "aliases": [], "versions": {"16": {"facts": [{"label": "Name", "value": "pg_create_subscription"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/16/sql-createsubscription.html", "label": "CREATE SUBSCRIPTION"}], "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": [], "description": ["Allow users with CREATE permission on the database to issue CREATE SUBSCRIPTION ."]}, "17": {"facts": [{"label": "Name", "value": "pg_create_subscription"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/17/sql-createsubscription.html", "label": "CREATE SUBSCRIPTION"}], "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": [], "description": ["Allow users with CREATE permission on the database to issue CREATE SUBSCRIPTION ."]}, "18": {"facts": [{"label": "Name", "value": "pg_create_subscription"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/18/sql-createsubscription.html", "label": "CREATE SUBSCRIPTION"}], "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-CREATE-SUBSCRIPTION", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-CREATE-SUBSCRIPTION", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["pg_create_subscription allows users with CREATE permission on the database to issue CREATE SUBSCRIPTION ."]}, "19": {"facts": [{"label": "Name", "value": "pg_create_subscription"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/19/sql-createsubscription.html", "label": "CREATE SUBSCRIPTION"}], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, "sources": [{"url": "/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-CREATE-SUBSCRIPTION", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-CREATE-SUBSCRIPTION", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["pg_create_subscription allows users with CREATE permission on the database to issue CREATE SUBSCRIPTION ."]}, "20": {"facts": [{"label": "Name", "value": "pg_create_subscription"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/devel/sql-createsubscription.html", "label": "CREATE SUBSCRIPTION"}], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, "sources": [{"url": "/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-CREATE-SUBSCRIPTION", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-CREATE-SUBSCRIPTION", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["pg_create_subscription allows users with CREATE permission on the database to issue CREATE SUBSCRIPTION ."]}}, "content_hash": "1e8a2459c7eb1f6a029fb1c8682e0e75aa0ecefb63c28ad470cc6d63fa9a3920", "imported_at": "2026-09-27T09:57:59.042", "url": "/wiki/role/pg_create_subscription/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_create_subscription/?v=10"}, {"major": "11", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 11.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_create_subscription/?v=11"}, {"major": "12", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 12.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_create_subscription/?v=12"}, {"major": "13", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 13.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_create_subscription/?v=13"}, {"major": "14", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 14.24 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_create_subscription/?v=14"}, {"major": "15", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 15.19 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_create_subscription/?v=15"}, {"major": "16", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 16.15 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_create_subscription/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_create_subscription/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_create_subscription/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_create_subscription/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_create_subscription/?v=20"}], "present": true}, {"slug": "pg_database_owner", "name": "pg_database_owner", "name_zh": "pg_database_owner", "category": "Administration", "summary": "pg_database_owner always has exactly one implicit member: the current database owner. It cannot be granted membership in any role, and no role can be granted membership in pg_database_owner . However, like any other role, it can own objects and receive grants of access privileges. Consequently, once pg_database_owner has rights within a template database, each owner of a database instantiated from that template will possess those rights. Initially, this role owns the public schema, so each database owner governs local use of that schema.", "aliases": [], "versions": {"14": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"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_database_owner role has one implicit, situation-dependent member, namely the owner of the current database. The role conveys no rights at first. Like any role, it can own objects or receive grants of access privileges. Consequently, once pg_database_owner has rights within a template database, each owner of a database instantiated from that template will exercise those rights. pg_database_owner cannot be a member of any role, and it cannot have non-implicit members."]}], "description": ["None. Membership consists, implicitly, of the current database owner."]}, "15": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"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_database_owner role has one implicit, situation-dependent member, namely the owner of the current database. Like any role, it can own objects or receive grants of access privileges. Consequently, once pg_database_owner has rights within a template database, each owner of a database instantiated from that template will exercise those rights. pg_database_owner cannot be a member of any role, and it cannot have non-implicit members. Initially, this role owns the public schema, so each database owner governs local use of the schema."]}], "description": ["None. Membership consists, implicitly, of the current database owner."]}, "16": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"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_database_owner role has one implicit, situation-dependent member, namely the owner of the current database. Like any role, it can own objects or receive grants of access privileges. Consequently, once pg_database_owner has rights within a template database, each owner of a database instantiated from that template will exercise those rights. pg_database_owner cannot be a member of any role, and it cannot have non-implicit members. Initially, this role owns the public schema, so each database owner governs local use of the schema."]}], "description": ["None. Membership consists, implicitly, of the current database owner."]}, "17": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"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_database_owner role has one implicit, situation-dependent member, namely the owner of the current database. Like any role, it can own objects or receive grants of access privileges. Consequently, once pg_database_owner has rights within a template database, each owner of a database instantiated from that template will exercise those rights. pg_database_owner cannot be a member of any role, and it cannot have non-implicit members. Initially, this role owns the public schema, so each database owner governs local use of the schema."]}], "description": ["None. Membership consists, implicitly, of the current database owner."]}, "18": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"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-DATABASE-OWNER", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["pg_database_owner always has exactly one implicit member: the current database owner. It cannot be granted membership in any role, and no role can be granted membership in pg_database_owner . However, like any other role, it can own objects and receive grants of access privileges. Consequently, once pg_database_owner has rights within a template database, each owner of a database instantiated from that template will possess those rights. Initially, this role owns the public schema, so each database owner governs local use of that schema."]}, "19": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"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-DATABASE-OWNER", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["pg_database_owner always has exactly one implicit member: the current database owner. It cannot be granted membership in any role, and no role can be granted membership in pg_database_owner . However, like any other role, it can own objects and receive grants of access privileges. Consequently, once pg_database_owner has rights within a template database, each owner of a database instantiated from that template will possess those rights. Initially, this role owns the public schema, so each database owner governs local use of that schema."]}, "20": {"facts": [{"label": "Name", "value": "pg_database_owner"}, {"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-DATABASE-OWNER", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-DATABASE-OWNER", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["pg_database_owner always has exactly one implicit member: the current database owner. It cannot be granted membership in any role, and no role can be granted membership in pg_database_owner . However, like any other role, it can own objects and receive grants of access privileges. Consequently, once pg_database_owner has rights within a template database, each owner of a database instantiated from that template will possess those rights. Initially, this role owns the public schema, so each database owner governs local use of that schema."]}}, "content_hash": "8ff3eb66690f329a62d6ab42bf0721b4144b8bedf0bd6803214e9ca07a3df2b1", "imported_at": "2026-09-27T09:57:59.044", "url": "/wiki/role/pg_database_owner/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_database_owner/?v=10"}, {"major": "11", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 11.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_database_owner/?v=11"}, {"major": "12", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 12.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_database_owner/?v=12"}, {"major": "13", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 13.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_database_owner/?v=13"}, {"major": "14", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 14.24 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_database_owner/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_database_owner/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_database_owner/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_database_owner/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_database_owner/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_database_owner/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_database_owner/?v=20"}], "present": true}, {"slug": "pg_read_all_data", "name": "pg_read_all_data", "name_zh": "pg_read_all_data", "category": "Data access", "summary": "pg_read_all_data allows reading all data (tables, views, sequences), as if having SELECT rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to.", "aliases": [], "versions": {"14": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"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": [], "description": ["Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "15": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"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": [], "description": ["Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "16": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"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": [], "description": ["Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "17": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"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": [], "description": ["Read all data (tables, views, sequences), as if having SELECT rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "18": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"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-READ-ALL-DATA", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["pg_read_all_data allows reading all data (tables, views, sequences), as if having SELECT rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to."]}, "19": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"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-READ-ALL-DATA", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["pg_read_all_data allows reading all data (tables, views, sequences, large objects), as if having SELECT rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to."]}, "20": {"facts": [{"label": "Name", "value": "pg_read_all_data"}, {"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-READ-ALL-DATA", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["pg_read_all_data allows reading all data (tables, views, sequences, large objects), as if having SELECT rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to."]}}, "content_hash": "4c1c6e5a63d184de658c43acd28b7a1577dd488ef82b99495a47b5f20c6ffe9a", "imported_at": "2026-09-27T09:57:59.053", "url": "/wiki/role/pg_read_all_data/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_read_all_data/?v=10"}, {"major": "11", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 11.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_read_all_data/?v=11"}, {"major": "12", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 12.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_read_all_data/?v=12"}, {"major": "13", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 13.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_read_all_data/?v=13"}, {"major": "14", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 14.24 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_read_all_data/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_data/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_data/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_data/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_data/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_data/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_read_all_data/?v=20"}], "present": true}, {"slug": "pg_write_all_data", "name": "pg_write_all_data", "name_zh": "pg_write_all_data", "category": "Data access", "summary": "pg_write_all_data allows writing all data (tables, views, sequences), as if having INSERT , UPDATE , and DELETE rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to.", "aliases": [], "versions": {"14": {"facts": [{"label": "Name", "value": "pg_write_all_data"}, {"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": [], "description": ["Write all data (tables, views, sequences), as if having INSERT , UPDATE , and DELETE rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "15": {"facts": [{"label": "Name", "value": "pg_write_all_data"}, {"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": [], "description": ["Write all data (tables, views, sequences), as if having INSERT , UPDATE , and DELETE rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "16": {"facts": [{"label": "Name", "value": "pg_write_all_data"}, {"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": [], "description": ["Write all data (tables, views, sequences), as if having INSERT , UPDATE , and DELETE rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "17": {"facts": [{"label": "Name", "value": "pg_write_all_data"}, {"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": [], "description": ["Write all data (tables, views, sequences), as if having INSERT , UPDATE , and DELETE rights on those objects, and USAGE rights on all schemas, even without having it explicitly. This role does not have the role attribute BYPASSRLS set. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is GRANTed to."]}, "18": {"facts": [{"label": "Name", "value": "pg_write_all_data"}, {"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-READ-ALL-DATA", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["pg_write_all_data allows writing all data (tables, views, sequences), as if having INSERT , UPDATE , and DELETE rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to."]}, "19": {"facts": [{"label": "Name", "value": "pg_write_all_data"}, {"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-READ-ALL-DATA", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["pg_write_all_data allows writing all data (tables, views, sequences, large objects), as if having INSERT , UPDATE , and DELETE rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to."]}, "20": {"facts": [{"label": "Name", "value": "pg_write_all_data"}, {"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-READ-ALL-DATA", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-READ-ALL-DATA", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["pg_write_all_data allows writing all data (tables, views, sequences, large objects), as if having INSERT , UPDATE , and DELETE rights on those objects and USAGE rights on all schemas. This role does not bypass row-level security (RLS) policies. If RLS is being used, an administrator may wish to set BYPASSRLS on roles which this role is granted to."]}}, "content_hash": "2436644025bf2f2440c1c79ab66a1bd4d7a73c6dc7984d8946c4ae32abf52b52", "imported_at": "2026-09-27T09:57:59.065", "url": "/wiki/role/pg_write_all_data/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_write_all_data/?v=10"}, {"major": "11", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 11.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_write_all_data/?v=11"}, {"major": "12", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 12.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_write_all_data/?v=12"}, {"major": "13", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 13.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_write_all_data/?v=13"}, {"major": "14", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 14.24 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_write_all_data/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_write_all_data/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_write_all_data/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_write_all_data/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_write_all_data/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_write_all_data/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_write_all_data/?v=20"}], "present": true}, {"slug": "pg_checkpoint", "name": "pg_checkpoint", "name_zh": "pg_checkpoint", "category": "Maintenance", "summary": "pg_checkpoint allows executing the CHECKPOINT command.", "aliases": [], "versions": {"15": {"facts": [{"label": "Name", "value": "pg_checkpoint"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/15/sql-checkpoint.html", "label": "CHECKPOINT"}], "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": [], "description": ["Allow executing the CHECKPOINT command."]}, "16": {"facts": [{"label": "Name", "value": "pg_checkpoint"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/16/sql-checkpoint.html", "label": "CHECKPOINT"}], "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": [], "description": ["Allow executing the CHECKPOINT command."]}, "17": {"facts": [{"label": "Name", "value": "pg_checkpoint"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/17/sql-checkpoint.html", "label": "CHECKPOINT"}], "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": [], "description": ["Allow executing the CHECKPOINT command."]}, "18": {"facts": [{"label": "Name", "value": "pg_checkpoint"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/18/sql-checkpoint.html", "label": "CHECKPOINT"}], "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-CHECKPOINT", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-CHECKPOINT", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["pg_checkpoint allows executing the CHECKPOINT command."]}, "19": {"facts": [{"label": "Name", "value": "pg_checkpoint"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/19/sql-checkpoint.html", "label": "CHECKPOINT"}], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, "sources": [{"url": "/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-CHECKPOINT", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-CHECKPOINT", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["pg_checkpoint allows executing the CHECKPOINT command."]}, "20": {"facts": [{"label": "Name", "value": "pg_checkpoint"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/devel/sql-checkpoint.html", "label": "CHECKPOINT"}], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, "sources": [{"url": "/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-CHECKPOINT", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-CHECKPOINT", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["pg_checkpoint allows executing the CHECKPOINT command."]}}, "content_hash": "a13141cf8d249da95db2d75597e149bd6e18c41bd842ca9823e15c2f116f7961", "imported_at": "2026-09-27T09:57:59.040", "url": "/wiki/role/pg_checkpoint/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_checkpoint/?v=10"}, {"major": "11", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 11.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_checkpoint/?v=11"}, {"major": "12", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 12.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_checkpoint/?v=12"}, {"major": "13", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 13.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_checkpoint/?v=13"}, {"major": "14", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 14.24 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_checkpoint/?v=14"}, {"major": "15", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 15.19 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_checkpoint/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_checkpoint/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_checkpoint/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_checkpoint/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_checkpoint/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_checkpoint/?v=20"}], "present": true}, {"slug": "pg_maintain", "name": "pg_maintain", "name_zh": "pg_maintain", "category": "Maintenance", "summary": "pg_maintain allows executing VACUUM , ANALYZE , CLUSTER , REFRESH MATERIALIZED VIEW , REINDEX , and LOCK TABLE on all relations, as if having MAINTAIN rights on those objects.", "aliases": [], "versions": {"17": {"facts": [{"label": "Name", "value": "pg_maintain"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/17/sql-vacuum.html", "label": "VACUUM"}, {"url": "/docs/17/sql-analyze.html", "label": "ANALYZE"}, {"url": "/docs/17/sql-cluster.html", "label": "CLUSTER"}, {"url": "/docs/17/sql-refreshmaterializedview.html", "label": "REFRESH MATERIALIZED VIEW"}, {"url": "/docs/17/sql-reindex.html", "label": "REINDEX"}, {"url": "/docs/17/sql-lock.html", "label": "LOCK TABLE"}], "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": [], "description": ["Allow executing VACUUM , ANALYZE , CLUSTER , REFRESH MATERIALIZED VIEW , REINDEX , and LOCK TABLE on all relations, as if having MAINTAIN rights on those objects, even without having it explicitly."]}, "18": {"facts": [{"label": "Name", "value": "pg_maintain"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/18/sql-vacuum.html", "label": "VACUUM"}, {"url": "/docs/18/sql-analyze.html", "label": "ANALYZE"}, {"url": "/docs/18/sql-cluster.html", "label": "CLUSTER"}, {"url": "/docs/18/sql-refreshmaterializedview.html", "label": "REFRESH MATERIALIZED VIEW"}, {"url": "/docs/18/sql-reindex.html", "label": "REINDEX"}, {"url": "/docs/18/sql-lock.html", "label": "LOCK TABLE"}], "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-MAINTAIN", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MAINTAIN", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["pg_maintain allows executing VACUUM , ANALYZE , CLUSTER , REFRESH MATERIALIZED VIEW , REINDEX , and LOCK TABLE on all relations, as if having MAINTAIN rights on those objects."]}, "19": {"facts": [{"label": "Name", "value": "pg_maintain"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/19/sql-vacuum.html", "label": "VACUUM"}, {"url": "/docs/19/sql-analyze.html", "label": "ANALYZE"}, {"url": "/docs/19/sql-cluster.html", "label": "CLUSTER"}, {"url": "/docs/19/sql-repack.html", "label": "REPACK"}, {"url": "/docs/19/sql-refreshmaterializedview.html", "label": "REFRESH MATERIALIZED VIEW"}, {"url": "/docs/19/sql-reindex.html", "label": "REINDEX"}, {"url": "/docs/19/sql-lock.html", "label": "LOCK TABLE"}], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, "sources": [{"url": "/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-MAINTAIN", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-MAINTAIN", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["pg_maintain allows executing VACUUM , ANALYZE , CLUSTER , REPACK , REFRESH MATERIALIZED VIEW , REINDEX , and LOCK TABLE on all relations, as if having MAINTAIN rights on those objects."]}, "20": {"facts": [{"label": "Name", "value": "pg_maintain"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/devel/sql-vacuum.html", "label": "VACUUM"}, {"url": "/docs/devel/sql-analyze.html", "label": "ANALYZE"}, {"url": "/docs/devel/sql-cluster.html", "label": "CLUSTER"}, {"url": "/docs/devel/sql-repack.html", "label": "REPACK"}, {"url": "/docs/devel/sql-refreshmaterializedview.html", "label": "REFRESH MATERIALIZED VIEW"}, {"url": "/docs/devel/sql-reindex.html", "label": "REINDEX"}, {"url": "/docs/devel/sql-lock.html", "label": "LOCK TABLE"}], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, "sources": [{"url": "/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-MAINTAIN", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-MAINTAIN", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["pg_maintain allows executing VACUUM , ANALYZE , CLUSTER , REPACK , REFRESH MATERIALIZED VIEW , REINDEX , and LOCK TABLE on all relations, as if having MAINTAIN rights on those objects."]}}, "content_hash": "69f17beb21d3eeeda1e7e1b74b617eb04b853d11aec2556d616af51d62d1f08f", "imported_at": "2026-09-27T09:57:59.049", "url": "/wiki/role/pg_maintain/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_maintain/?v=10"}, {"major": "11", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 11.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_maintain/?v=11"}, {"major": "12", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 12.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_maintain/?v=12"}, {"major": "13", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 13.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_maintain/?v=13"}, {"major": "14", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 14.24 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_maintain/?v=14"}, {"major": "15", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 15.19 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_maintain/?v=15"}, {"major": "16", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 16.15 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_maintain/?v=16"}, {"major": "17", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 17.11 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_maintain/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_maintain/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_maintain/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_maintain/?v=20"}], "present": true}, {"slug": "pg_monitor", "name": "pg_monitor", "name_zh": "pg_monitor", "category": "Monitoring and statistics", "summary": "pg_monitor allows reading/executing various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables .", "aliases": [], "versions": {"10": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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/execute various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}, "11": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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/execute various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}, "12": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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/execute various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}, "13": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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/execute various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}, "14": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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/execute various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}, "15": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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/execute various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}, "16": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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/execute various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}, "17": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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/execute various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}, "18": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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_monitor allows reading/executing various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}, "19": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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_monitor allows reading/executing various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}, "20": {"facts": [{"label": "Name", "value": "pg_monitor"}, {"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_monitor allows reading/executing various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."]}}, "content_hash": "9ffded9bcb2385bda86d0823231d45934eb73d4aa9c118f0fce1c28ec38e7f57", "imported_at": "2026-09-27T09:57:59.051", "url": "/wiki/role/pg_monitor/?v=18", "cells": [{"major": "10", "state": "present", "label": "Recorded", "title": "PostgreSQL 10.23 \u00b7 Recorded", "url": "/wiki/role/pg_monitor/?v=10"}, {"major": "11", "state": "present", "label": "Recorded", "title": "PostgreSQL 11.22 \u00b7 Recorded", "url": "/wiki/role/pg_monitor/?v=11"}, {"major": "12", "state": "present", "label": "Recorded", "title": "PostgreSQL 12.22 \u00b7 Recorded", "url": "/wiki/role/pg_monitor/?v=12"}, {"major": "13", "state": "present", "label": "Recorded", "title": "PostgreSQL 13.23 \u00b7 Recorded", "url": "/wiki/role/pg_monitor/?v=13"}, {"major": "14", "state": "changed", "label": "Interface or attribute change", "title": "PostgreSQL 14.24 \u00b7 Interface or attribute change", "url": "/wiki/role/pg_monitor/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_monitor/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_monitor/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_monitor/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_monitor/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_monitor/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_monitor/?v=20"}], "present": true}, {"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", "url": "/wiki/role/pg_read_all_settings/?v=18", "cells": [{"major": "10", "state": "present", "label": "Recorded", "title": "PostgreSQL 10.23 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_settings/?v=10"}, {"major": "11", "state": "present", "label": "Recorded", "title": "PostgreSQL 11.22 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_settings/?v=11"}, {"major": "12", "state": "present", "label": "Recorded", "title": "PostgreSQL 12.22 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_settings/?v=12"}, {"major": "13", "state": "present", "label": "Recorded", "title": "PostgreSQL 13.23 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_settings/?v=13"}, {"major": "14", "state": "changed", "label": "Interface or attribute change", "title": "PostgreSQL 14.24 \u00b7 Interface or attribute change", "url": "/wiki/role/pg_read_all_settings/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_settings/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_settings/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_settings/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_settings/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_settings/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_read_all_settings/?v=20"}], "present": true}, {"slug": "pg_read_all_stats", "name": "pg_read_all_stats", "name_zh": "pg_read_all_stats", "category": "Monitoring and statistics", "summary": "pg_read_all_stats allows reading all pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers.", "aliases": [], "versions": {"10": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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 pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}, "11": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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 pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}, "12": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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 pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}, "13": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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 pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}, "14": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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 pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}, "15": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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 pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}, "16": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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 pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}, "17": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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 pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}, "18": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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_stats allows reading all pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}, "19": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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_stats allows reading all pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}, "20": {"facts": [{"label": "Name", "value": "pg_read_all_stats"}, {"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_stats allows reading all pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers."]}}, "content_hash": "90208d2f13c20be05f2925e06af29506c048893e8910c2237870ba9689cfa7b1", "imported_at": "2026-09-27T09:57:59.056", "url": "/wiki/role/pg_read_all_stats/?v=18", "cells": [{"major": "10", "state": "present", "label": "Recorded", "title": "PostgreSQL 10.23 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_stats/?v=10"}, {"major": "11", "state": "present", "label": "Recorded", "title": "PostgreSQL 11.22 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_stats/?v=11"}, {"major": "12", "state": "present", "label": "Recorded", "title": "PostgreSQL 12.22 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_stats/?v=12"}, {"major": "13", "state": "present", "label": "Recorded", "title": "PostgreSQL 13.23 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_stats/?v=13"}, {"major": "14", "state": "changed", "label": "Interface or attribute change", "title": "PostgreSQL 14.24 \u00b7 Interface or attribute change", "url": "/wiki/role/pg_read_all_stats/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_stats/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_stats/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_stats/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_stats/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_read_all_stats/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_read_all_stats/?v=20"}], "present": true}, {"slug": "pg_stat_scan_tables", "name": "pg_stat_scan_tables", "name_zh": "pg_stat_scan_tables", "category": "Monitoring and statistics", "summary": "pg_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension).", "aliases": [], "versions": {"10": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"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": ["Execute monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time."]}, "11": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"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": ["Execute monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time."]}, "12": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"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": ["Execute monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time."]}, "13": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"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": ["Execute monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time."]}, "14": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"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": ["Execute monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time."]}, "15": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"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": ["Execute monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time."]}, "16": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"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": ["Execute monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time."]}, "17": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"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": ["Execute monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time."]}, "18": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/18/pgrowlocks.html", "label": "pgrowlocks"}], "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_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension)."]}, "19": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/19/pgrowlocks.html", "label": "pgrowlocks"}], "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_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension)."]}, "20": {"facts": [{"label": "Name", "value": "pg_stat_scan_tables"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/devel/pgrowlocks.html", "label": "pgrowlocks"}], "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_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension)."]}}, "content_hash": "02d8b39ab1178693e7d01101c4cad60e4749e97dff1287001352d0b576fc0ac2", "imported_at": "2026-09-27T09:57:59.063", "url": "/wiki/role/pg_stat_scan_tables/?v=18", "cells": [{"major": "10", "state": "present", "label": "Recorded", "title": "PostgreSQL 10.23 \u00b7 Recorded", "url": "/wiki/role/pg_stat_scan_tables/?v=10"}, {"major": "11", "state": "present", "label": "Recorded", "title": "PostgreSQL 11.22 \u00b7 Recorded", "url": "/wiki/role/pg_stat_scan_tables/?v=11"}, {"major": "12", "state": "present", "label": "Recorded", "title": "PostgreSQL 12.22 \u00b7 Recorded", "url": "/wiki/role/pg_stat_scan_tables/?v=12"}, {"major": "13", "state": "present", "label": "Recorded", "title": "PostgreSQL 13.23 \u00b7 Recorded", "url": "/wiki/role/pg_stat_scan_tables/?v=13"}, {"major": "14", "state": "changed", "label": "Interface or attribute change", "title": "PostgreSQL 14.24 \u00b7 Interface or attribute change", "url": "/wiki/role/pg_stat_scan_tables/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_stat_scan_tables/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_stat_scan_tables/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_stat_scan_tables/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_stat_scan_tables/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_stat_scan_tables/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_stat_scan_tables/?v=20"}], "present": true}, {"slug": "pg_signal_autovacuum_worker", "name": "pg_signal_autovacuum_worker", "name_zh": "pg_signal_autovacuum_worker", "category": "Processes and connections", "summary": "pg_signal_autovacuum_worker allows signaling autovacuum workers to cancel the current table's vacuum or terminate its session. See Section 9.28.2 .", "aliases": [], "versions": {"18": {"facts": [{"label": "Name", "value": "pg_signal_autovacuum_worker"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/18/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.28.2"}], "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-SIGNAL-AUTOVACUUM-WORKER", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-SIGNAL-AUTOVACUUM-WORKER", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["pg_signal_autovacuum_worker allows signaling autovacuum workers to cancel the current table's vacuum or terminate its session. See Section 9.28.2 ."]}, "19": {"facts": [{"label": "Name", "value": "pg_signal_autovacuum_worker"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/19/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.29.2"}], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, "sources": [{"url": "/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-SIGNAL-AUTOVACUUM-WORKER", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-SIGNAL-AUTOVACUUM-WORKER", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["pg_signal_autovacuum_worker allows signaling autovacuum workers to cancel the current table's vacuum or terminate its session. See Section 9.29.2 ."]}, "20": {"facts": [{"label": "Name", "value": "pg_signal_autovacuum_worker"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/devel/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.29.2"}], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, "sources": [{"url": "/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-SIGNAL-AUTOVACUUM-WORKER", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-SIGNAL-AUTOVACUUM-WORKER", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["pg_signal_autovacuum_worker allows signaling autovacuum workers to cancel the current table's vacuum or terminate its session. See Section 9.29.2 ."]}}, "content_hash": "39bab6320c6b6e0a2b99cba43a9d1b05bee70da87bc4a4f7406d39bb8b1422b5", "imported_at": "2026-09-27T09:57:59.060", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=10"}, {"major": "11", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 11.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=11"}, {"major": "12", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 12.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=12"}, {"major": "13", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 13.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=13"}, {"major": "14", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 14.24 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=14"}, {"major": "15", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 15.19 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=15"}, {"major": "16", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 16.15 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=16"}, {"major": "17", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 17.11 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=17"}, {"major": "18", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 18.6 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_signal_autovacuum_worker/?v=20"}], "present": true}, {"slug": "pg_signal_backend", "name": "pg_signal_backend", "name_zh": "pg_signal_backend", "category": "Processes and connections", "summary": "pg_signal_backend allows signaling another backend to cancel a query or terminate its session. Note that this role does not permit signaling backends owned by a superuser. See Section 9.28.2 .", "aliases": [], "versions": {"10": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Default roles"}], "related": [{"url": "/docs/10/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.26.2"}], "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_signal_backend role is intended to allow administrators to enable trusted, but non-superuser, roles to send signals to other backends. Currently this role enables sending of signals for canceling a query on another backend or terminating its session. A user granted this role cannot however send signals to a backend owned by a superuser. See Section 9.26.2 ."]}], "description": ["Signal another backend to cancel a query or terminate its session."]}, "11": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Default roles"}], "related": [{"url": "/docs/11/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.26.2"}], "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_signal_backend role is intended to allow administrators to enable trusted, but non-superuser, roles to send signals to other backends. Currently this role enables sending of signals for canceling a query on another backend or terminating its session. A user granted this role cannot however send signals to a backend owned by a superuser. See Section 9.26.2 ."]}], "description": ["Signal another backend to cancel a query or terminate its session."]}, "12": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Default roles"}], "related": [{"url": "/docs/12/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.26.2"}], "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_signal_backend role is intended to allow administrators to enable trusted, but non-superuser, roles to send signals to other backends. Currently this role enables sending of signals for canceling a query on another backend or terminating its session. A user granted this role cannot however send signals to a backend owned by a superuser. See Section 9.26.2 ."]}], "description": ["Signal another backend to cancel a query or terminate its session."]}, "13": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Default roles"}], "related": [{"url": "/docs/13/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.27.2"}], "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_signal_backend role is intended to allow administrators to enable trusted, but non-superuser, roles to send signals to other backends. Currently this role enables sending of signals for canceling a query on another backend or terminating its session. A user granted this role cannot however send signals to a backend owned by a superuser. See Section 9.27.2 ."]}], "description": ["Signal another backend to cancel a query or terminate its session."]}, "14": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/14/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.27.2"}], "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_signal_backend role is intended to allow administrators to enable trusted, but non-superuser, roles to send signals to other backends. Currently this role enables sending of signals for canceling a query on another backend or terminating its session. A user granted this role cannot however send signals to a backend owned by a superuser. See Section 9.27.2 ."]}], "description": ["Signal another backend to cancel a query or terminate its session."]}, "15": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/15/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.27.2"}], "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_signal_backend role is intended to allow administrators to enable trusted, but non-superuser, roles to send signals to other backends. Currently this role enables sending of signals for canceling a query on another backend or terminating its session. A user granted this role cannot however send signals to a backend owned by a superuser. See Section 9.27.2 ."]}], "description": ["Signal another backend to cancel a query or terminate its session."]}, "16": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/16/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.27.2"}], "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_signal_backend role is intended to allow administrators to enable trusted, but non-superuser, roles to send signals to other backends. Currently this role enables sending of signals for canceling a query on another backend or terminating its session. A user granted this role cannot however send signals to a backend owned by a superuser. See Section 9.27.2 ."]}], "description": ["Signal another backend to cancel a query or terminate its session."]}, "17": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/17/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.28.2"}], "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_signal_backend role is intended to allow administrators to enable trusted, but non-superuser, roles to send signals to other backends. Currently this role enables sending of signals for canceling a query on another backend or terminating its session. A user granted this role cannot however send signals to a backend owned by a superuser. See Section 9.28.2 ."]}], "description": ["Signal another backend to cancel a query or terminate its session."]}, "18": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/18/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.28.2"}], "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-SIGNAL-BACKEND", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-SIGNAL-BACKEND", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["pg_signal_backend allows signaling another backend to cancel a query or terminate its session. Note that this role does not permit signaling backends owned by a superuser. See Section 9.28.2 ."]}, "19": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/19/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.29.2"}], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, "sources": [{"url": "/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-SIGNAL-BACKEND", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-SIGNAL-BACKEND", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["pg_signal_backend allows signaling another backend to cancel a query or terminate its session. Note that this role does not permit signaling backends owned by a superuser. See Section 9.29.2 ."]}, "20": {"facts": [{"label": "Name", "value": "pg_signal_backend"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/devel/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL", "label": "Section 9.29.2"}], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, "sources": [{"url": "/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-SIGNAL-BACKEND", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-SIGNAL-BACKEND", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["pg_signal_backend allows signaling another backend to cancel a query or terminate its session. Note that this role does not permit signaling backends owned by a superuser. See Section 9.29.2 ."]}}, "content_hash": "31bc9ebffe6acd5c756b7545a62fd684f5cc609a3287c8f0368ace0608656327", "imported_at": "2026-09-27T09:57:59.061", "url": "/wiki/role/pg_signal_backend/?v=18", "cells": [{"major": "10", "state": "present", "label": "Recorded", "title": "PostgreSQL 10.23 \u00b7 Recorded", "url": "/wiki/role/pg_signal_backend/?v=10"}, {"major": "11", "state": "present", "label": "Recorded", "title": "PostgreSQL 11.22 \u00b7 Recorded", "url": "/wiki/role/pg_signal_backend/?v=11"}, {"major": "12", "state": "present", "label": "Recorded", "title": "PostgreSQL 12.22 \u00b7 Recorded", "url": "/wiki/role/pg_signal_backend/?v=12"}, {"major": "13", "state": "present", "label": "Recorded", "title": "PostgreSQL 13.23 \u00b7 Recorded", "url": "/wiki/role/pg_signal_backend/?v=13"}, {"major": "14", "state": "changed", "label": "Interface or attribute change", "title": "PostgreSQL 14.24 \u00b7 Interface or attribute change", "url": "/wiki/role/pg_signal_backend/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_signal_backend/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_signal_backend/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_signal_backend/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_signal_backend/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_signal_backend/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_signal_backend/?v=20"}], "present": true}, {"slug": "pg_use_reserved_connections", "name": "pg_use_reserved_connections", "name_zh": "pg_use_reserved_connections", "category": "Processes and connections", "summary": "pg_use_reserved_connections allows use of connection slots reserved via reserved_connections .", "aliases": [], "versions": {"16": {"facts": [{"label": "Name", "value": "pg_use_reserved_connections"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/16/runtime-config-connection.html#GUC-RESERVED-CONNECTIONS", "label": "reserved_connections"}], "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": [], "description": ["Allow use of connection slots reserved via reserved_connections ."]}, "17": {"facts": [{"label": "Name", "value": "pg_use_reserved_connections"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/17/runtime-config-connection.html#GUC-RESERVED-CONNECTIONS", "label": "reserved_connections"}], "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": [], "description": ["Allow use of connection slots reserved via reserved_connections ."]}, "18": {"facts": [{"label": "Name", "value": "pg_use_reserved_connections"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/18/runtime-config-connection.html#GUC-RESERVED-CONNECTIONS", "label": "reserved_connections"}], "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-USE-RESERVED-CONNECTIONS", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-USE-RESERVED-CONNECTIONS", "label": "PostgreSQL 18 online manual"}], "sections": [], "description": ["pg_use_reserved_connections allows use of connection slots reserved via reserved_connections ."]}, "19": {"facts": [{"label": "Name", "value": "pg_use_reserved_connections"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/19/runtime-config-connection.html#GUC-RESERVED-CONNECTIONS", "label": "reserved_connections"}], "release": {"ref": "PostgreSQL 19beta4 Documentation", "label": "19beta4", "major": "19", "channel": "preview", "revision": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, "sources": [{"url": "/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-USE-RESERVED-CONNECTIONS", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-USE-RESERVED-CONNECTIONS", "label": "PostgreSQL 19 online manual"}], "sections": [], "description": ["pg_use_reserved_connections allows use of connection slots reserved via reserved_connections ."]}, "20": {"facts": [{"label": "Name", "value": "pg_use_reserved_connections"}, {"label": "Manual terminology", "value": "Predefined roles"}], "related": [{"url": "/docs/devel/runtime-config-connection.html#GUC-RESERVED-CONNECTIONS", "label": "reserved_connections"}], "release": {"ref": "PostgreSQL 20devel Documentation", "label": "20devel", "major": "20", "channel": "devel", "revision": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, "sources": [{"url": "/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-USE-RESERVED-CONNECTIONS", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-USE-RESERVED-CONNECTIONS", "label": "PostgreSQL devel online manual"}], "sections": [], "description": ["pg_use_reserved_connections allows use of connection slots reserved via reserved_connections ."]}}, "content_hash": "e3562f9f49819b91a50fc42b521be53f85bd77911884447d3354f3b44efec7b2", "imported_at": "2026-09-27T09:57:59.064", "url": "/wiki/role/pg_use_reserved_connections/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_use_reserved_connections/?v=10"}, {"major": "11", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 11.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_use_reserved_connections/?v=11"}, {"major": "12", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 12.22 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_use_reserved_connections/?v=12"}, {"major": "13", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 13.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_use_reserved_connections/?v=13"}, {"major": "14", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 14.24 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_use_reserved_connections/?v=14"}, {"major": "15", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 15.19 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_use_reserved_connections/?v=15"}, {"major": "16", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 16.15 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_use_reserved_connections/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_use_reserved_connections/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_use_reserved_connections/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_use_reserved_connections/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_use_reserved_connections/?v=20"}], "present": true}, {"slug": "pg_execute_server_program", "name": "pg_execute_server_program", "name_zh": "pg_execute_server_program", "category": "Server files and programs", "summary": "pg_execute_server_program allows executing programs on the database server as the user the database runs as using COPY and other functions which allow executing a server-side program.", "aliases": [], "versions": {"11": {"facts": [{"label": "Name", "value": "pg_execute_server_program"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow executing programs on the database server as the user the database runs as with COPY and other functions which allow executing a server-side program."]}, "12": {"facts": [{"label": "Name", "value": "pg_execute_server_program"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow executing programs on the database server as the user the database runs as with COPY and other functions which allow executing a server-side program."]}, "13": {"facts": [{"label": "Name", "value": "pg_execute_server_program"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow executing programs on the database server as the user the database runs as with COPY and other functions which allow executing a server-side program."]}, "14": {"facts": [{"label": "Name", "value": "pg_execute_server_program"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow executing programs on the database server as the user the database runs as with COPY and other functions which allow executing a server-side program."]}, "15": {"facts": [{"label": "Name", "value": "pg_execute_server_program"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow executing programs on the database server as the user the database runs as with COPY and other functions which allow executing a server-side program."]}, "16": {"facts": [{"label": "Name", "value": "pg_execute_server_program"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow executing programs on the database server as the user the database runs as with COPY and other functions which allow executing a server-side program."]}, "17": {"facts": [{"label": "Name", "value": "pg_execute_server_program"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow executing programs on the database server as the user the database runs as with COPY and other functions which allow executing a server-side program."]}, "18": {"facts": [{"label": "Name", "value": "pg_execute_server_program"}, {"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-READ-SERVER-FILES", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-SERVER-FILES", "label": "PostgreSQL 18 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. They bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access. Therefore, great care should be taken when granting these roles to users."]}], "description": ["pg_execute_server_program allows executing programs on the database server as the user the database runs as using COPY and other functions which allow executing a server-side program."]}, "19": {"facts": [{"label": "Name", "value": "pg_execute_server_program"}, {"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-READ-SERVER-FILES", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-READ-SERVER-FILES", "label": "PostgreSQL 19 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. They bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access. Therefore, great care should be taken when granting these roles to users."]}], "description": ["pg_execute_server_program allows executing programs on the database server as the user the database runs as using COPY and other functions which allow executing a server-side program."]}, "20": {"facts": [{"label": "Name", "value": "pg_execute_server_program"}, {"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-READ-SERVER-FILES", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-READ-SERVER-FILES", "label": "PostgreSQL devel online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. They bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access. Therefore, great care should be taken when granting these roles to users."]}], "description": ["pg_execute_server_program allows executing programs on the database server as the user the database runs as using COPY and other functions which allow executing a server-side program."]}}, "content_hash": "92d2d8d272fc216417a4d76606df0eb59e311538754370148e0e226c50b19e16", "imported_at": "2026-09-27T09:57:59.047", "url": "/wiki/role/pg_execute_server_program/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_execute_server_program/?v=10"}, {"major": "11", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 11.22 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_execute_server_program/?v=11"}, {"major": "12", "state": "present", "label": "Recorded", "title": "PostgreSQL 12.22 \u00b7 Recorded", "url": "/wiki/role/pg_execute_server_program/?v=12"}, {"major": "13", "state": "present", "label": "Recorded", "title": "PostgreSQL 13.23 \u00b7 Recorded", "url": "/wiki/role/pg_execute_server_program/?v=13"}, {"major": "14", "state": "changed", "label": "Interface or attribute change", "title": "PostgreSQL 14.24 \u00b7 Interface or attribute change", "url": "/wiki/role/pg_execute_server_program/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_execute_server_program/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_execute_server_program/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_execute_server_program/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_execute_server_program/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_execute_server_program/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_execute_server_program/?v=20"}], "present": true}, {"slug": "pg_read_server_files", "name": "pg_read_server_files", "name_zh": "pg_read_server_files", "category": "Server files and programs", "summary": "pg_read_server_files allows reading files from any location the database can access on the server using COPY and other file-access functions.", "aliases": [], "versions": {"11": {"facts": [{"label": "Name", "value": "pg_read_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow reading files from any location the database can access on the server with COPY and other file-access functions."]}, "12": {"facts": [{"label": "Name", "value": "pg_read_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow reading files from any location the database can access on the server with COPY and other file-access functions."]}, "13": {"facts": [{"label": "Name", "value": "pg_read_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow reading files from any location the database can access on the server with COPY and other file-access functions."]}, "14": {"facts": [{"label": "Name", "value": "pg_read_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow reading files from any location the database can access on the server with COPY and other file-access functions."]}, "15": {"facts": [{"label": "Name", "value": "pg_read_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow reading files from any location the database can access on the server with COPY and other file-access functions."]}, "16": {"facts": [{"label": "Name", "value": "pg_read_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow reading files from any location the database can access on the server with COPY and other file-access functions."]}, "17": {"facts": [{"label": "Name", "value": "pg_read_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow reading files from any location the database can access on the server with COPY and other file-access functions."]}, "18": {"facts": [{"label": "Name", "value": "pg_read_server_files"}, {"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-READ-SERVER-FILES", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-SERVER-FILES", "label": "PostgreSQL 18 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. They bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access. Therefore, great care should be taken when granting these roles to users."]}], "description": ["pg_read_server_files allows reading files from any location the database can access on the server using COPY and other file-access functions."]}, "19": {"facts": [{"label": "Name", "value": "pg_read_server_files"}, {"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-READ-SERVER-FILES", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-READ-SERVER-FILES", "label": "PostgreSQL 19 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. They bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access. Therefore, great care should be taken when granting these roles to users."]}], "description": ["pg_read_server_files allows reading files from any location the database can access on the server using COPY and other file-access functions."]}, "20": {"facts": [{"label": "Name", "value": "pg_read_server_files"}, {"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-READ-SERVER-FILES", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-READ-SERVER-FILES", "label": "PostgreSQL devel online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. They bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access. Therefore, great care should be taken when granting these roles to users."]}], "description": ["pg_read_server_files allows reading files from any location the database can access on the server using COPY and other file-access functions."]}}, "content_hash": "166c5be61f71d590283caf0619819126895da21722bd3b0550507361601b40ca", "imported_at": "2026-09-27T09:57:59.058", "url": "/wiki/role/pg_read_server_files/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_read_server_files/?v=10"}, {"major": "11", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 11.22 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_read_server_files/?v=11"}, {"major": "12", "state": "present", "label": "Recorded", "title": "PostgreSQL 12.22 \u00b7 Recorded", "url": "/wiki/role/pg_read_server_files/?v=12"}, {"major": "13", "state": "present", "label": "Recorded", "title": "PostgreSQL 13.23 \u00b7 Recorded", "url": "/wiki/role/pg_read_server_files/?v=13"}, {"major": "14", "state": "changed", "label": "Interface or attribute change", "title": "PostgreSQL 14.24 \u00b7 Interface or attribute change", "url": "/wiki/role/pg_read_server_files/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_read_server_files/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_read_server_files/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_read_server_files/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_read_server_files/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_read_server_files/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_read_server_files/?v=20"}], "present": true}, {"slug": "pg_write_server_files", "name": "pg_write_server_files", "name_zh": "pg_write_server_files", "category": "Server files and programs", "summary": "pg_write_server_files allows writing to files in any location the database can access on the server using COPY and other file-access functions.", "aliases": [], "versions": {"11": {"facts": [{"label": "Name", "value": "pg_write_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow writing to files in any location the database can access on the server with COPY and other file-access functions."]}, "12": {"facts": [{"label": "Name", "value": "pg_write_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow writing to files in any location the database can access on the server with COPY and other file-access functions."]}, "13": {"facts": [{"label": "Name", "value": "pg_write_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow writing to files in any location the database can access on the server with COPY and other file-access functions."]}, "14": {"facts": [{"label": "Name", "value": "pg_write_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow writing to files in any location the database can access on the server with COPY and other file-access functions."]}, "15": {"facts": [{"label": "Name", "value": "pg_write_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow writing to files in any location the database can access on the server with COPY and other file-access functions."]}, "16": {"facts": [{"label": "Name", "value": "pg_write_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow writing to files in any location the database can access on the server with COPY and other file-access functions."]}, "17": {"facts": [{"label": "Name", "value": "pg_write_server_files"}, {"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_read_server_files , pg_write_server_files and pg_execute_server_program roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. As these roles are able to access any file on the server file system, they bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access, therefore great care should be taken when granting these roles to users."]}], "description": ["Allow writing to files in any location the database can access on the server with COPY and other file-access functions."]}, "18": {"facts": [{"label": "Name", "value": "pg_write_server_files"}, {"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-READ-SERVER-FILES", "label": "PostgreSQL 18.6 Documentation", "sha256": "b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"}, {"url": "https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-READ-SERVER-FILES", "label": "PostgreSQL 18 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. They bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access. Therefore, great care should be taken when granting these roles to users."]}], "description": ["pg_write_server_files allows writing to files in any location the database can access on the server using COPY and other file-access functions."]}, "19": {"facts": [{"label": "Name", "value": "pg_write_server_files"}, {"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-READ-SERVER-FILES", "label": "PostgreSQL 19beta4 Documentation", "sha256": "f758684af9560594d8d6fa264fa05b8d9437883c8999dc9a387cc4ed235fcbe6"}, {"url": "https://www.postgresql.org/docs/19/predefined-roles.html#PREDEFINED-ROLE-PG-READ-SERVER-FILES", "label": "PostgreSQL 19 online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. They bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access. Therefore, great care should be taken when granting these roles to users."]}], "description": ["pg_write_server_files allows writing to files in any location the database can access on the server using COPY and other file-access functions."]}, "20": {"facts": [{"label": "Name", "value": "pg_write_server_files"}, {"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-READ-SERVER-FILES", "label": "PostgreSQL 20devel Documentation", "sha256": "6850783e0465f49a366ff444d6c3b5674ee11d2fc310d6fdaed5c84781e83ca7"}, {"url": "https://www.postgresql.org/docs/devel/predefined-roles.html#PREDEFINED-ROLE-PG-READ-SERVER-FILES", "label": "PostgreSQL devel online manual"}], "sections": [{"title": "Privileges and scope", "paragraphs": ["These roles are intended to allow administrators to have trusted, but non-superuser, roles which are able to access files and run programs on the database server as the user the database runs as. They bypass all database-level permission checks when accessing files directly and they could be used to gain superuser-level access. Therefore, great care should be taken when granting these roles to users."]}], "description": ["pg_write_server_files allows writing to files in any location the database can access on the server using COPY and other file-access functions."]}}, "content_hash": "8a8b425e462095f3a6023a014bb2c06b8e7c460595cc2b6f78035ca19ea15c45", "imported_at": "2026-09-27T09:57:59.067", "url": "/wiki/role/pg_write_server_files/?v=18", "cells": [{"major": "10", "state": "absent", "label": "Not recorded in this version", "title": "PostgreSQL 10.23 \u00b7 Not recorded in this version", "url": "/wiki/role/pg_write_server_files/?v=10"}, {"major": "11", "state": "added", "label": "First recorded in this sample", "title": "PostgreSQL 11.22 \u00b7 First recorded in this sample", "url": "/wiki/role/pg_write_server_files/?v=11"}, {"major": "12", "state": "present", "label": "Recorded", "title": "PostgreSQL 12.22 \u00b7 Recorded", "url": "/wiki/role/pg_write_server_files/?v=12"}, {"major": "13", "state": "present", "label": "Recorded", "title": "PostgreSQL 13.23 \u00b7 Recorded", "url": "/wiki/role/pg_write_server_files/?v=13"}, {"major": "14", "state": "changed", "label": "Interface or attribute change", "title": "PostgreSQL 14.24 \u00b7 Interface or attribute change", "url": "/wiki/role/pg_write_server_files/?v=14"}, {"major": "15", "state": "present", "label": "Recorded", "title": "PostgreSQL 15.19 \u00b7 Recorded", "url": "/wiki/role/pg_write_server_files/?v=15"}, {"major": "16", "state": "present", "label": "Recorded", "title": "PostgreSQL 16.15 \u00b7 Recorded", "url": "/wiki/role/pg_write_server_files/?v=16"}, {"major": "17", "state": "present", "label": "Recorded", "title": "PostgreSQL 17.11 \u00b7 Recorded", "url": "/wiki/role/pg_write_server_files/?v=17"}, {"major": "18", "state": "present", "label": "Recorded", "title": "PostgreSQL 18.6 \u00b7 Recorded", "url": "/wiki/role/pg_write_server_files/?v=18"}, {"major": "19", "state": "present", "label": "Recorded", "title": "PostgreSQL 19beta4 \u00b7 Recorded", "url": "/wiki/role/pg_write_server_files/?v=19"}, {"major": "20", "state": "present", "label": "Recorded", "title": "PostgreSQL 20devel \u00b7 Recorded", "url": "/wiki/role/pg_write_server_files/?v=20"}], "present": true}], "total": 16, "present": 16, "collection_tables": []}