Get in Touch
 Duration 14 hours

Course Outline

1. PostgreSQL Standard Replication

  • Physical replication via WAL streaming
  • Distinction between synchronous and asynchronous replication
  • Setup of Primary and Standby server configurations
  • Application of replication slots
  • Execution of manual failover
  • Implementation of logical replication

2. Managing Replication with RepMgr

  • Overview of RepMgr components and repository structure
  • Installation and initial configuration
  • Process of registering cluster nodes
  • Creation of Standby servers
  • Performing switchover and failover operations
  • Automating failover through repmgrd

3. High Availability with PgPool-II

  • Understanding PgPool-II architecture
  • Installation and configuration steps
  • Managing PgPool-II start and stop operations
  • Utilizing basic administration tools and commands
  • Orchestrating replication and load balancing
  • Setting up automatic failover and failback mechanisms
  • Leveraging the Watchdog architecture
  • Implementing connection pooling

Requirements

  • Solid grasp of PostgreSQL architecture and configuration parameters
  • Proficiency in Linux command-line operations and general database administration

Target Audience

Database Administrators, DevOps Engineers, and System Architects tasked with maintaining database reliability, redundancy, and continuous uptime.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories