Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
1. Standard PostgreSQL Replication
- Physical replication via WAL streaming
- Synchronous versus asynchronous replication models
- Setting up Primary and Standby server nodes
- Leveraging replication slots
- Executing manual failover processes
- Implementing logical replication
2. Replication Management via RepMgr
- Overview of RepMgr components and repository structure
- Deployment and configuration procedures
- Node registration workflows
- Establishing Standby servers
- Managing switchover and failover events
- Automating failover using repmgrd
3. Achieving High Availability with PgPool-II
- Understanding PgPool-II architecture
- Installation and setup guidelines
- Controlling PgPool-II service lifecycle (start/stop)
- Utilizing core administration tools and commands
- Overseeing replication flows and load distribution
- Setting up automatic failover and failback mechanisms
- Implementing Watchdog architecture
- Optimizing connection pooling
Requirements
- Solid grasp of PostgreSQL architecture and its configuration parameters
- Proficiency in Linux command-line operations and routine database administration
Target Audience
Database Administrators, DevOps Engineers, and System Architects tasked with maintaining database reliability, redundancy, and system uptime.
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