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
- Differences between synchronous and asynchronous replication
- Configuration of Primary and Standby nodes
- Utilization of replication slots
- Executing manual failover procedures
- Implementing logical replication
2. Replication Management via RepMgr
- Overview of RepMgr components and its repository
- Deployment and configuration steps
- Registration of cluster nodes
- Provisioning Standby servers
- Executing switchover and failover operations
- Implementing automatic failover using repmgrd
3. High Availability Using PgPool-II
- PgPool-II architectural concepts
- Installation and configuration workflows
- Controlling PgPool-II service states (start/stop)
- Essential administrative tools and commands
- Orchestrating replication and load balancing
- Setup of automatic failover and failback mechanisms
- Implementation of Watchdog architecture
- Application of connection pooling
Requirements
- Solid grasp of PostgreSQL internal architecture and configuration parameters
- Proficiency in Linux command-line operations and core database administration duties
Target Audience
This course is tailored for Database Administrators, DevOps Engineers, and System Architects 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