PostgreSQL

• How to connect to PostgreSQL databases
  • Sample ~/.pg_service.conf
  • Sample ~/.pgpass
• How to manage the PostgreSQL backups
  • List the servers with backups
  • List the backups of a server
  • Manually delete a backup
  • Manually start a backup
• Postgresql running in Kubernetes with CloudNativePG operator
  • staging
  • staging-next-version
  • production
• Postgresql Upgrades and Maintenance with CloudNativePG cluster
  • Upgrade
  • Postgresql upgrade
    • minor version
    • major version
  • Postgresql Operator upgrade
  • Kubernetes Upgrade
    • staging
    • staging-next-version
    • production