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 and asynchronous replication methods
- Setting up Primary and Standby servers
- Utilizing replication slots
- Executing manual failover
- Logical replication techniques
2. Replication Management via RepMgr
- RepMgr components and its repository
- Deployment and configuration
- Node registration
- Provisioning Standby servers
- Handling switchover and failover
- Automating failover using repmgrd
3. Achieving High Availability with PgPool-II
- PgPool-II architectural overview
- Installation and setup
- Managing PgPool-II start and stop operations
- Essential administrative tools and commands
- Overseeing replication and load balancing
- Setting up automatic failover and failback
- Leveraging Watchdog architecture
- Connection pooling implementation
Requirements
- A solid grasp of PostgreSQL architecture and configuration
- Hands-on experience with Linux command-line operations and database administration
Target Audience
Professionals such as Database Administrators, DevOps Engineers, and System Architects who are tasked with ensuring database reliability, redundancy, and consistent 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