Wiki / Predefined Roles / Maintenance

pg_maintain

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.

Reading PostgreSQL 18.6.

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.

Name: pg_maintain
Manual terminology: Predefined roles

Related entries

Documentation and source

Source build

Version: 18.6
Build: PostgreSQL 18.6 Documentation
Source fingerprint: b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75

Compare versions

PostgreSQL 16 → 17: added.

--- PostgreSQL 16
+++ PostgreSQL 17
@@ -1 +1,14 @@
-Not recorded in this version
+{
+  "facts": [
+    {
+      "label": "Name",
+      "value": "pg_maintain"
+    },
+    {
+      "label": "Manual terminology",
+      "value": "Predefined roles"
+    }
+  ],
+  "signature": null,
+  "tables": null
+}

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

pg_checkpointpg_checkpoint

Export JSON · Back to Predefined Roles · Recorded in PostgreSQL 17 through 20; the first sample is not necessarily its introduction.