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 using WAL streaming
- Synchronous versus asynchronous replication modes
- Setting up Primary and Standby instances
- Leveraging replication slots
- Executing manual failovers
- Implementing logical replication
2. Replication Management via RepMgr
- Understanding RepMgr components and repository structures
- Installation and configuration processes
- Registering cluster nodes
- Provisioning Standby servers
- Managing switchover and failover events
- Enabling automatic failover through repmgrd
3. High Availability via PgPool-II
- PgPool-II architectural overview
- Installation and configuration steps
- Controlling PgPool-II start/stop cycles
- Utilizing essential administration tools and commands
- Overseeing replication and load balancing
- Configuring automated failover and failback mechanisms
- Implementing Watchdog architecture
- Managing connection pooling
Requirements
- Solid grasp of PostgreSQL architecture and configuration parameters
- Proficiency with Linux command-line interfaces and database administration workflows
Target Audience
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