PostgreSQL Containerized Deployment in Kubernetes

LEVEL: Expert

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.

Book Now

Course Topics

Understanding the Kubernetes architecture
Setting up and managing a Kubernetes development-environment
Implementing the Postgres Operator
Use of Patroni for cluster management

Target audience

DB Administrators
DevOps Engineers
System Administrators
Software Developers
IT Architects

Prerequisites

Basic knowledge of SQL
Basic Linux skills (e.g., using commands and a text editor)
Completion of the „PostgreSQL Administration and Performance Tuning“ course is required to fulfill this prerequisite
Familiarity with Patroni: A basic understanding of Patroni and its role in ensuring the high availability of PostgreSQL is required.
Completion of the „PostgreSQL High Availability Architecture with Patroni“ course fulfills this prerequisite
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.