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
- Setup and configuration of Primary and Standby servers
- Leveraging replication slots
- Executing manual failover procedures
- Implementing logical replication
2. Replication Management with RepMgr
- Overview of RepMgr components and repository structure
- Installation and initial configuration
- Registering cluster nodes
- Provisioning Standby servers
- Managing switchover and failover events
- Achieving automatic failover through repmgrd
3. High Availability using PgPool-II
- PgPool-II architectural principles
- Installation and configuration procedures
- Controlling PgPool-II service start and stop
- Utilizing core administrative tools and commands
- Managing replication flows and load distribution
- Setting up automatic failover and failback mechanisms
- Implementing Watchdog architecture
- Configuring connection pooling strategies
Requirements
- A solid grasp of PostgreSQL architecture and configuration parameters
- Proficiency in Linux command-line operations and general database administration tasks
Target Audience
Database Administrators, DevOps Engineers, and System Architects who are tasked with maintaining database reliability, redundancy, and continuous 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