Manage System
These topics cover day-to-day maintenance after the cluster is live: monitoring its state, configuring security and permissions, backing up and restoring data, resizing the cluster, and upgrading.
Monitor and configure
DBCC provides dashboards and metrics for clusters and databases, and can manage several clusters at once.
A cluster is made of several PostgreSQL instances, so configuration has to stay consistent across them.
Security and permissions
Password policies, roles and privileges, encryption, anonymization, and audit logging.
Protect data
Full and incremental backups, the parallel versus non-parallel trade-off, and the CBDR tool.
Change the cluster
Scale elastically with gpexpand to grow and gpshrink to shrink.
The general upgrade process and its quality assurance measures.
In-place major version upgrade that runs pg_upgrade across all segments, with no export and reload.