Course Outline
1. PostgreSQL Standard Replication
- Physical replication (WAL streaming)
- Synchronous and asynchronous replication modes
- Setting up Primary and Standby servers
- Utilization of replication slots
- Performing manual failover
- Logical replication
2. Managing Replication with RepMgr
- RepMgr components and repository structure
- Installation and configuration procedures
- Node registration processes
- Creating Standby servers
- Executing switchover and failover
- Automated failover using repmgrd
3. High Availability with PgPool-II
- PgPool-II architecture overview
- Installation and configuration steps
- Managing PgPool-II start and stop operations
- Essential administration tools and commands
- Handling replication and load balancing
- Configuring automated failover and failback
- Implementing Watchdog architecture
- Connection pooling mechanisms
Requirements
- A solid grasp of PostgreSQL architecture and configuration
- Hands-on experience with Linux command-line operations and database administration tasks
Target Audience
Database Administrators, DevOps Engineers, and System Architects tasked with maintaining database reliability, redundancy, and uptime.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
I expanded my knowledge on DB performance management, some are directly usable while others provide great insight/context for me.
Longze Chen - Center for Open Science
Course - PostgreSQL Advanced - Performance Management
how to use LLM in daily work
Cont - Everymatrix
Course - PostgreSQL AI: Introduction to semantic search
Tables indexes and qq reperforming & tuning in order to improve them