Documentation / Predefined Roles / Maintenance
pg_maintain
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
Related entries
pg_checkpointpg_checkpoint
Back to Predefined Roles · Recorded in PostgreSQL 17 through 20; the first sample is not necessarily its introduction.