In this course, participants will learn how to deploy and manage PostgreSQL databases in a containerised Kubernetes environment. The training provides a comprehensive introduction to the concepts of Kubernetes, including container orchestration and architecture. Participants will become familiar with the setup and management of Kubernetes environments, the use of storage volumes and the implementation of the Postgres Operator and Patroni to efficiently manage PostgreSQL instances. Through practical exercises and examples, participants will acquire the necessary skills to successfully run PostgreSQL in Kubernetes.
Knowledge of container technologies: A foundational understanding of the concepts of containerization
As containers and associated technologies are not PostgreSQLspecific, preparation on these areas are recommended
What you will learn
Understanding the Kubernetes architecture: Participants will develop a solid understanding of the Kubernetes architecture and container orchestration concepts.
Setting up and managing Kubernetes environments: Participants will gain the skills to effectively set up and manage Kubernetes environments, including the use of tools such as Minikube and kubectl.
Efficiently managing PostgreSQL with Postgres Operator: Participants will learn how to configure and manage Postgres Operator to efficiently run PostgreSQL databases in Kubernetes.
Implementing Patroni for High Availability: Participants will be able to implement Patroni in Kubernetes to manage PostgreSQL clusters, including scaling, backups and configuration changes.
Dealing with storage solutions in Kubernetes: Participants will learn how to deal with different storage options in Kubernetes, including persistent volumes and their configuration for PostgreSQL.
Kubernetes Fundamentals: Participants will understand the basic concepts of Kubernetes, including architecture, containerisation and orchestration.
Administration with Postgres Operator: Participants will have a comprehensive knowledge of how to configure and administer Postgres Operator to manage PostgreSQL databases in Kubernetes.
Course content
Module 1: Introduction to Kubernetes
Containers: understanding containers and their importance in software development.
Kubernetes architecture: overview of the main components and their functions, including resource management and networking.
Container orchestration: introduction to container orchestration and how the reconciliation loop works in Kubernetes.
Module 2: Setting up the Kubernetes environment
Installation Methods and Minikube: various methods for installing Kubernetes, including the use of Minikube for local development.
Kubectl and CLI Tools: using kubectl and other CLI tools to manage Kubernetes resources.
Pods, ConfigMap, and Secrets: fundamentals of pod management and the use of ConfigMaps and Secrets for configuration and sensitive data.
Module 3: Storage management in Kubernetes
Storage Volumes: introduction to different types of storage volumes, including emptyDir and HostPath.
Persistent Volumes and Claims: managing persistent storage solutions and provisioning them dynamically or statically.
Module 4: Postgres Operator
Concept and configuration: introduction to the Postgres Operator and its customisation options.
Administration: management and monitoring of PostgreSQL instances, including backup and recovery strategies.
Module 5: Patroni in Kubernetes
High Availability: understanding how Patroni works and how to use it to ensure availability.
Database management: administration of PostgreSQL databases and roles as well as backup strategies (logical and continuous).
Course materials and environment
We will provide access to a dedicated tab environment and virtual machines running a Linux distribution.
Upon completion of the course, participants will receive a PDF of the slide deck that was used during the training sessions.
All scripts and configuration files present on the virtual machines during training will be available for download and use.
Upon completion of the course, participants will receive a complimentry copy of the most recent edition of Hans-Jürgens Schönig’s book Mastering PostgreSQL.
