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
- Implementing synchronous and asynchronous replication models
- Setting up Primary and Standby server instances
- Leveraging replication slots for data consistency
- Executing manual failover procedures
- Implementing logical replication strategies
2. Replication Management with RepMgr
- Understanding RepMgr components and its repository structure
- Deployment and initial configuration steps
- Enrolling nodes into the cluster
- Provisioning Standby servers
- Performing controlled switchover and failover operations
- Achieving automatic failover through repmgrd
3. High Availability Implementation with PgPool-II
- Overview of the PgPool-II architectural design
- Installation and detailed configuration
- Controlling PgPool-II service startup and shutdown
- Utilizing essential administration tools and commands
- Oversight of replication flows and load balancing distribution
- Setting up automatic failover and failback mechanisms
- Deploying the Watchdog architecture for enhanced resilience
- Optimizing performance through connection pooling
Requirements
- Solid grasp of PostgreSQL architecture and configuration fundamentals
- Proficiency with the Linux command line and standard database administration duties
Target Audience
Professionals such as Database Administrators, DevOps Engineers, and System Architects tasked with maintaining database reliability, redundancy, and operational 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