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. PostgreSQL Standard Replication
- Physical replication utilizing WAL streaming
- Implementing synchronous and asynchronous replication models
- Setting up Primary and Standby server instances
- Leveraging replication slots for resource management
- Executing manual failover procedures
- Exploring logical replication methods
2. Managing Replication with RepMgr
- Understanding RepMgr components and its repository structure
- Handling installation and initial configuration
- Registering cluster nodes for management
- Provisioning Standby servers
- Performing planned switchover and emergency failover operations
- Enabling automated failover through repmgrd
3. High Availability with PgPool-II
- Overview of the PgPool-II architecture
- Installation and configuration workflows
- Managing PgPool-II service lifecycle (start/stop)
- Utilizing core administrative tools and commands
- Orchestrating replication and load balancing strategies
- Configuring automatic failover and failback mechanisms
- Implementing Watchdog architecture for fault detection
- Optimizing performance through connection pooling
Requirements
- A solid grasp of PostgreSQL architecture and configuration parameters
- Proficiency with Linux command-line operations and standard database administrative tasks
Target Audience
Professionals such as Database Administrators, DevOps Engineers, and System Architects who are tasked with maintaining database reliability, redundancy, and 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