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
- Configuring Primary and Standby servers
- Using replication slots
- Manual failover
- Logical replication
2. Managing Replication with RepMgr
- RepMgr components and repository
- Installation and configuration
- Registering nodes
- Creating Standby servers
- Switchover and failover
- Automatic failover with repmgrd
3. High Availability with PgPool-II
- PgPool-II architecture
- Installing and configuring
- Starting/stopping PgPool-II
- Basic administration tools and commands
- Managing replication and load balancing
- Configuring automatic failover and failback
- Using Watchdog architecture
- Connection pooling
Requirements
- Good understanding of PostgreSQL architecture and configuration
- Experience with Linux command line and database administration tasks
Audience
Database Administrators, DevOps Engineers, and System Architects responsible for ensuring 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