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 (WAL streaming)
- Synchronous and asynchronous replication models
- Setting up Primary and Standby servers
- Utilising replication slots
- Executing manual failover
- Logical replication
2. Managing Replication with RepMgr
- RepMgr components and repository structure
- Installation and configuration processes
- Registering nodes in the cluster
- Provisioning Standby servers
- Performing switchover and failover operations
- Achieving automatic failover with repmgrd
3. High Availability with PgPool-II
- PgPool-II architectural overview
- Installation and configuration steps
- Controlling PgPool-II start and stop operations
- Essential administrative tools and commands
- Overseeing replication and load balancing
- Configuring automatic failover and failback mechanisms
- Leveraging Watchdog architecture
- Implementing connection pooling
Requirements
- A solid grasp of PostgreSQL architecture and configuration
- Proficiency with Linux command line interfaces and database administration tasks
Audience
Database Administrators, DevOps Engineers, and System Architects tasked with maintaining database reliability, redundancy, and 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