Get in Touch
 Duration 14 hours

Course Outline

1. PostgreSQL Standard Replication

  • Physical replication (WAL streaming)
  • Synchronous and asynchronous replication
  • Configuring Primary and Standby servers
  • Utilizing replication slots
  • Manual failover procedures
  • Logical replication techniques

2. Managing Replication with RepMgr

  • RepMgr components and repository structure
  • Installation and configuration steps
  • Registering cluster nodes
  • Creating Standby servers
  • Performing Switchover and failover
  • Automatic failover via repmgrd

3. High Availability with PgPool-II

  • PgPool-II architectural overview
  • Installation and configuration
  • Starting and stopping PgPool-II
  • Core administration tools and commands
  • Managing replication and load balancing
  • Configuring automatic failover and failback
  • Implementing Watchdog architecture
  • Connection pooling mechanisms

Requirements

  • A solid grasp of PostgreSQL architecture and configuration
  • Proficiency in Linux command-line operations and database administration

Audience

Database Administrators, DevOps Engineers, and System Architects tasked with maintaining database reliability, redundancy, and operational 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.
Investment

Price per private group, online live training, starting from 2900 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (3)

Upcoming Courses

Related Categories