Get in Touch
 Duration 14 hours

Course Outline

1. Standard PostgreSQL Replication

  • Physical replication via WAL streaming
  • Synchronous and asynchronous replication modes
  • Setting up Primary and Standby servers
  • Utilizing replication slots
  • Executing manual failover
  • Logical replication

2. Replication Management with RepMgr

  • Understanding RepMgr components and the repository
  • Installation and configuration steps
  • Registering cluster nodes
  • Provisioning Standby servers
  • Performing switchover and failover
  • Implementing automatic failover with repmgrd

3. Achieving High Availability with PgPool-II

  • Overview of PgPool-II architecture
  • Installation and configuration
  • Starting and stopping PgPool-II services
  • Essential administrative tools and commands
  • Controlling replication and load balancing
  • Setting up automatic failover and failback
  • Leveraging the Watchdog architecture
  • Connection pooling techniques

Requirements

  • A solid grasp of PostgreSQL architecture and configuration
  • Practical experience with Linux command-line operations and database administration

Target Audience

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

Testimonials (3)

Upcoming Courses

Related Categories