Skip to content
Hands-on IT IT Drills
Cover: PostgreSQL hands-on

Training material

PostgreSQL hands-on

Running the database – from a server to CloudNativePG on Kubernetes

Two VMs and a Kubernetes cluster – psql, roles and privileges, configuration and TLS, MVCC and locking, indexes and EXPLAIN, VACUUM, monitoring, logical and physical backups with point-in-time recovery, pgBackRest, streaming and logical replication, PgBouncer, a major upgrade, then CloudNativePG with backups, failover, poolers and monitoring, a competition on broken databases and a final exam.

  • PostgreSQL
  • Backup
  • Replikation
  • CloudNativePG
  • PgBouncer
Download for free PDF and EPUB · edition 2026 Read as a course

Training plan

  1. Welcome to the Drills
  2. Day 0: Training Ground
  3. Day 1: psql Craft
  4. Day 2: Databases, Schemas, Roles and Privileges
  5. Day 3: Configuration and Access
  6. Day 4: Transactions, MVCC and Locks
  7. Day 5: Indexes and EXPLAIN
  8. Day 6: VACUUM, Autovacuum and Bloat
  9. Day 7: Monitoring and Logs
  10. Day 8: Logical Backups
  11. Day 9: Physical Backups and PITR
  12. Day 10: Streaming Replication
  13. Day 11: Logical Replication
  14. Day 12: Connection Pooling with PgBouncer
  15. Day 13: Major Upgrade
  16. Day 14: Installing CloudNativePG and Your First Cluster
  17. Day 15: CNPG: Backups and Recovery
  18. Day 16: CNPG: High Availability
  19. Day 17: CNPG: Operations
  20. Day 18: Connecting the Application
  21. Day 19: Competition – Repairing Broken Databases
  22. Appendix A: Cheat Sheet
  23. Appendix B: Final Exam