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
- Solid grasp of PostgreSQL architecture and configuration settings
- Proficiency with Linux command-line interfaces and database administration duties
Target Audience
Database Administrators, DevOps Engineers, and System Architects tasked with ensuring database reliability, redundancy, and uptime.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
Tuning strategies.
Jeffrey Zieg - Matrix Consulting
Course - PostgreSQL Performance Tuning
Logging behaviour when the instance is under stress, and the hierarchy/nomenclature of instances, databases, files, etc.
