PostgreSQL High Availability & Patroni Cluster Manager
Dates & Times
See available dates for this High Availability & Patroni course!
If there is no date and time available for a certain training you are interested in, please contact us.
The training takes 4 days. In addition, a further day can be booked, during which we’ll address individual questions.
Summary
This course is intended for PostgreSQL users who are interested in fully automating high availability operations.
The course first gives an overview of the general high availability landscape in PostgreSQL clusters and then focuses on the very popular (open source) cluster manager «Patroni».
Audience Requirements
Target group for this course are experienced PostgreSQL users with at least basic Linux knowledge (command line, editing of configuration files)
AGENDA
Overview of PostgreSQL High Availability (HA)
- binary replication
- typical replication problems and solutions
- built-in HA mechanisms
- switchover and failover
- logical replication
HA automation
- basic concepts
- standard HA problems
- decisions with consent
- different approaches
Patroni
- basic idea & introduction
- installation
- configuration & operation
- common problems
Patronictl
- extended functionalities
- postgresql.conf + pg_hba.conf replacement
Routing of client requests
- libpq/JDBC
- vip manager
- HAProxy
Updates and upgrades
- PostgreSQL updates
- Patroni updates
Contact us to sign up for this course >>
Other courses that might interest you
We offer these services
PostgreSQL Optimization & Security
Is your database not running smoothly or are you struggling with security issues? Our experts will analyze problems & optimization potentials within a health check or security audit.
PostgreSQL Infrastructure
PostgreSQL Setup & Installation, automation with Kubernetes and database architecture: We’ll find the optimal setup and make sure that your PostgreSQL Infrastructure meets your needs and expectations.
PostgreSQL Setup & Installation
Get started with PostgreSQL by using our Setup & Installation service. We fully focus on your personal needs and infrastructure. In addition to the configuration itself, you also benefit from the knowledge of our experts in the field of database design.