{"Entry":{"collection":"role","key":"pg_maintain","name":"pg_maintain","aliases":[],"metadata":{"aliases":[],"category":"Maintenance","content_hash":"69f17beb21d3eeeda1e7e1b74b617eb04b853d11aec2556d616af51d62d1f08f","derived_content_hash":"dabc987bb0dace939b823c6f3b87cd058e78c9164b344b5daa6fd7b607c78fc6","imported_at":"2026-09-27T17:57:59.049431+08:00","name":"pg_maintain","name_zh":"pg_maintain","repair_provenance":{"original_source_revision":"","receipt_sha256":"61c27b4f39676dcb9f080fe9ae965675676d668ffc5066ff4689c28ee9ff6dda","repair":"wiki-repair-20261023"},"slug":"pg_maintain","source_rev":"wiki-repair-20261023:87b72e3e1a0eba548a2f68f3e542521645f2dc11c1ff058316b3878e0acff5ab","summary":"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."}},"Definition":{"Collection":"role","Key":"pg_maintain","SourceDatabase":"center","Version":"18","SourceTable":"predefined_role","SourceKey":"pg_maintain","SourceRevision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","Facts":{"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."],"description_zh":"pg_maintain 允许在所有关系上执行 VACUUM、ANALYZE、CLUSTER、REFRESH MATERIALIZED VIEW、REINDEX 以及 LOCK TABLE，其效果就像对这些对象拥有 MAINTAIN 权限一样。","description_zh_html":"\u003cp\u003e\n\u003ccode class=\"literal\"\u003epg_maintain\u003c/code\u003e 允许在所有关系上执行 \u003ca class=\"link\" href=\"/zh/docs/18/sql-vacuum.html\" title=\"VACUUM\"\u003e\u003ccode class=\"command\"\u003eVACUUM\u003c/code\u003e\u003c/a\u003e、\u003ca class=\"link\" href=\"/zh/docs/18/sql-analyze.html\" title=\"ANALYZE\"\u003e\u003ccode class=\"command\"\u003eANALYZE\u003c/code\u003e\u003c/a\u003e、\u003ca class=\"link\" href=\"/zh/docs/18/sql-cluster.html\" title=\"CLUSTER\"\u003e\u003ccode class=\"command\"\u003eCLUSTER\u003c/code\u003e\u003c/a\u003e、\u003ca class=\"link\" href=\"/zh/docs/18/sql-refreshmaterializedview.html\" title=\"REFRESH MATERIALIZED VIEW\"\u003e\u003ccode class=\"command\"\u003eREFRESH MATERIALIZED VIEW\u003c/code\u003e\u003c/a\u003e、\u003ca class=\"link\" href=\"/zh/docs/18/sql-reindex.html\" title=\"REINDEX\"\u003e\u003ccode class=\"command\"\u003eREINDEX\u003c/code\u003e\u003c/a\u003e\n       以及 \u003ca class=\"link\" href=\"/zh/docs/18/sql-lock.html\" title=\"LOCK\"\u003e\u003ccode class=\"command\"\u003eLOCK TABLE\u003c/code\u003e\u003c/a\u003e，其效果就像对这些对象拥有 \u003ccode class=\"literal\"\u003eMAINTAIN\u003c/code\u003e 权限一样。\n      \u003c/p\u003e","facts":[{"label":"Name","value":"pg_maintain"},{"label":"Manual terminology","value":"Predefined roles"}],"related":[{"label":"VACUUM","url":"/docs/18/sql-vacuum.html"},{"label":"ANALYZE","url":"/docs/18/sql-analyze.html"},{"label":"CLUSTER","url":"/docs/18/sql-cluster.html"},{"label":"REFRESH MATERIALIZED VIEW","url":"/docs/18/sql-refreshmaterializedview.html"},{"label":"REINDEX","url":"/docs/18/sql-reindex.html"},{"label":"LOCK TABLE","url":"/docs/18/sql-lock.html"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"PostgreSQL 18.6 Documentation","revision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"},"sections":[],"sources":[{"label":"PostgreSQL 18.6 Documentation","sha256":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","url":"/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MAINTAIN"},{"label":"PostgreSQL 18 online manual","url":"https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MAINTAIN"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/predefined-roles.html","sha256":"99e1fbd83b1da2cf9da5823238b31d78c953c6118ecc61939808d2bf32f9b56d"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"release":{"channel":"stable","label":"18.6","major":"18","ref":"PostgreSQL 18.6 Documentation","revision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"},"sources":[{"label":"PostgreSQL 18.6 Documentation","sha256":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","url":"/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MAINTAIN"},{"label":"PostgreSQL 18 online manual","url":"https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MAINTAIN"}]},"MeasuredEvidence":{}},"Text":{"Collection":"role","Key":"pg_maintain","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_maintain","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.","BodyHTML":"\u003cp\u003epg_maintain allows executing VACUUM , ANALYZE , CLUSTER , REFRESH MATERIALIZED VIEW , REINDEX , and LOCK TABLE on all relations, as if having MAINTAIN rights on those objects.\u003c/p\u003e","SourceRevision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","ContentHash":"29ccc513bea50c85a1e2f4454e2625ed6a0482f2d66e70e5be64fe3d53032e2f","Payload":{"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."],"related":[{"label":"VACUUM","url":"/docs/18/sql-vacuum.html"},{"label":"ANALYZE","url":"/docs/18/sql-analyze.html"},{"label":"CLUSTER","url":"/docs/18/sql-cluster.html"},{"label":"REFRESH MATERIALIZED VIEW","url":"/docs/18/sql-refreshmaterializedview.html"},{"label":"REINDEX","url":"/docs/18/sql-reindex.html"},{"label":"LOCK TABLE","url":"/docs/18/sql-lock.html"}],"sections":[]}},"RequestedLocale":"en","Fallback":false,"Versions":["17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}