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.
This training can also be held at your place or as online training especially for your company. In this case the course agenda can also be adapted to suit your needs best.Learn more about our customized training >>
This course takes 3 days with 8 hours each (on site) or 5 hours each (online).
The only difference is that there will be less practical exercises in an online course. However, we will hand them over to you and you can still do them on your own and ask our consultants for feedback or help if needed.
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”.
Target group for this course are experienced PostgreSQL users with at least basic Linux knowledge (command line, editing of configuration files)
This course can be held in English, German and Estonian.
Overview of PostgreSQL High Availability (HA)
- binary replication
- typical replication problems and solutions
- built-in HA mechanisms
- switchover and failover
- logical replication
- basic concepts
- standard HA problems
- decisions with consent
- different approaches
- basic idea & introduction
- configuration & operation
- extended functionalities
- postgresql.conf + pg_hba.conf replacement
- common problems
Routing of client requests
- vip manager
Updates and upgrades
- PostgreSQL updates
- Patroni updates
Contact us to sign up for this course >>
Other courses that might interest you
GIS ESSENTIALS – „GETTING SPATIALLY ENABLED“
PostgreSQL in Kubernetes
Machine Learning for decision makers
Introduction to Machine Learning
Introduction to PostGIS
PostgreSQL Administration and Performance Tuning
Introduction to SQL
PostgreSQL for business intelligence and mass data analysis
We offer these services
PostgreSQL Security Audit
In our security audit, our PostgreSQL consultants will review your system, document any vulnerabilities, and recommend ways to secure those weaknesses.
PostgreSQL makes achieving security goals easy: It has all tools to ensure maximum efficiency and superior security. We at CYBERTEC can help to protect your most valuable asset: Your data.
PostgreSQL Update & Upgrade
CYBERTEC can assist you in performing updates and upgrades, also during non-working hours, in order to avoid interruptions in your business operations.