Operations

This section describes day-to-day operations using pglift through available interfaces (command-line, Ansible, Python).

• Instance operations
  • Command line interface
  • Ansible module
• PostgreSQL configuration
  • pgconf commands
  • pghba commands
  • Changing managed configuration parameters
• Roles operations
  • Command line interface
  • Ansible module
• Databases operations
  • Command line interface
  • Ansible module
• Access privileges
  • Listing privileges
  • Alter privileges
• Role profiles
  • Assigning profile for a role, database and schema
• Backup
  • Instances
  • Databases logical backup (dump)
  • Scheduled backups
• High availability
  • Configuration
  • Logs
  • Operations
  • Environment and patronictl
  • Convert a standalone into a Patroni cluster member
  • Major upgrade of PostgreSQL version
  • Cluster removal
• Upgrade