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 via WAL streaming
- Distinction between synchronous and asynchronous replication
- Setup of Primary and Standby server configurations
- Application of replication slots
- Execution of manual failover
- Implementation of logical replication
2. Managing Replication with RepMgr
- Overview of RepMgr components and repository structure
- Installation and initial configuration
- Process of registering cluster nodes
- Creation of Standby servers
- Performing switchover and failover operations
- Automating failover through repmgrd
3. High Availability with PgPool-II
- Understanding PgPool-II architecture
- Installation and configuration steps
- Managing PgPool-II start and stop operations
- Utilizing basic administration tools and commands
- Orchestrating replication and load balancing
- Setting up automatic failover and failback mechanisms
- Leveraging the Watchdog architecture
- Implementing connection pooling
Requirements
- Solid grasp of PostgreSQL architecture and configuration parameters
- Proficiency in Linux command-line operations and general database administration
Target Audience
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