This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2015

Back

Automate High Availability using repmgr 3

Date: 2015-10-30
Time: 13:40–14:30
Room: Ballroom C+D
Level: Intermediate

In this talk we will set up a High Availability cluster using repmgr version 3. Issues and best practices will be discussed, including:

  • Automatic cluster configuration using Event Notification Commands

  • Integration with other tools (pg_basebackup, PgBouncer, Barman)

  • Switchover and maintenance

  • Read scalability, node priority, cascading replication

  • Automatic failover, witness nodes

  • Roadmap and wishlist

repmgr is an open-source software to manage replication and failover between multiple PostgreSQL servers. The latest stable version is 3.0.1, released in March 2015.

Speaker

Gianni Ciolli