Administration

Create/destroy PostgreSQL clusters, scale existing clusters, and clone clusters.

User management - create, modify, delete users, manage role membership, connection pool config

Database management - create, modify, delete, rebuild, and clone databases using templates

Manage PostgreSQL cluster HA with Patroni, including config changes, status check, switchover, restart, and reinit replica.

HBA management - refresh rules, verify config, troubleshoot, Pgbouncer HBA

Manage Pgbouncer connection pool, including pause, resume, disable, enable, reconnect, kill, and reload operations.

Use systemctl to manage PostgreSQL cluster component services - start, stop, restart, reload, and status check.

Configure crontab to schedule PostgreSQL backups, vacuum freeze, and bloat maintenance tasks

Extension management - download, install, configure, enable, update, and remove extensions

Version upgrade - minor version rolling upgrade, major version migration, extension upgrade