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