2ndQuadrant | PostgreSQL
Mission Critical Databases
+33 9 72 17 01 31
  • Contact
  • Support & Services
    • Support
      • 24/7 PostgreSQL Support
      • Support Développement
    • DBA Services
      • Administration à Distance – RDBA
      • Monitoring Base de Données
    • Services de Consulting
      • Bilan de santé PostgreSQL
      • Optimisation de Performances
      • Audit de Sécurité
      • Mise à Jour PostgreSQL
    • Services de Migration
      • Migrer vers PostgreSQL
      • Audit de Migrabilité
  • Produits
    • Postgres-BDR ®
    • Haute Disponibilité PostgreSQL
    • Operateurs Kubernetes pour BDR & PostgreSQL
    • PostgreSQL dans le Cloud
    • Installateurs
      • Postgres Installer
      • 2UDA
    • 2ndQPostgres
    • pglogical
    • Barman
    • repmgr
    • omniDB
    • SQL Firewall
    • Postgres-XL
  • Downloads
    • Installateurs
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Livres Blancs
      • Etude de cas pour le Support PostgreSQL
      • AlwaysOn Postgres
      • PostgreSQL avec Haute Disponibilité
      • Bonnes Pratiques de Sécurité
      • BDR
    • Etudes de Cas
      • Migration Base de Données
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
      • Optimisation de Performances
        • BenchPrep
        • tastyworks
      • Clusters Bases de Données Distribuées
        • ClickUp
        • European Space Agency (ESA)
        • Animal Logic
        • Telefónica del Sur
      • Mises à Jour Bases de Données
        • Alfred Wegener Institute (AWI)
      • Support & Administration Base de Données
        • Met Office
        • Agilis Systems
        • London & Partners
  • Formation: Postgres Learning Center
    • Webinars
      • Webinars à Venir
      • Archives – Webinar Library
    • Livres Blancs
      • Etude de cas pour le Support PostgreSQL
      • AlwaysOn Postgres
      • PostgreSQL avec Haute Disponibilité
      • Bonnes Pratiques de Sécurité
      • BDR
    • Blog
    • Formation
      • Catalogue des Formations
    • Etudes de Cas
      • Optimisation de Performances
        • BenchPrep
        • tastyworks
      • Clusters Distribués
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Administration Bases de Données
        • Agilis Systems
      • Formation Professionnelle
        • Met Office
        • London & Partners
      • Mises à Jour Base de Données
        • Alfred Wegener Institute (AWI)
      • Migration Base de Données
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Livres
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2ème Edition
      • PostgreSQL 9 Administration Cookbook – 3ème Edition
      • PostgreSQL Server Programming Cookbook – 2ème Edition
      • PostgreSQL 9 Cookbook – Edition en Chinois
    • Vidéos
    • Evènements
    • PostgreSQL
      • PostgreSQL – L’Histoire
      • Qui Utilise PostgreSQL?
      • Foire aux Questions PostgreSQL
      • PostgreSQL et MySQL
      • L’Etude de Cas pour PostgreSQL
      • Informations de Sécurité
      • Documentation
  • Nous Connaître
    • Qui est 2ndQuadrant?
    • Que signifie « 2ndQuadrant »?
    • 2ndQuadrant: la Passion pour PostgreSQL
    • Actualités
    • Carrières
  • Blog
  • Menu Menu
Vous êtes ici : Accueil1 / Products2 / Replication & Failover Management for Postgres

Replication & Failover Management for Postgres

repmgr – simplified management of replication, failover, & switchover for PostgreSQL clusters

repmgr is the most popular tool for PostgreSQL replication and failover management. repmgr simplifies administration and daily management, enhances productivity and complements built-in replication capabilities in PostgreSQL.

Introduced by 2ndQuadrant in 2010, repmgr takes advantage of PostgreSQL’s Hot Standby capability and greatly simplifies the process of setting up and managing databases with high availability and scalability requirements.

Documentation

FAQ’s

Reporting Issues

Availability

repmgr v5.2.0 released – 22 October, 2020

repmgr is available via 2ndQuadrant’s YUM repository for the Red Hat family (RHEL, CentOS, and Fedora) and PGDG’s APT repository for Debian (please use the test repository for the Beta version – more details at the installation instruction link below). You can use standard yum and apt package managers for installing repmgr with your instance of PostgreSQL.

(repmgr requires PostgreSQL 9.4 or higher)

Click here to view detailed installation instructions using yum and apt

Click here to view detailed upgrading instructions

Click here to download the latest tarball

Click here to view the release notes

Configurations

The images and explanation below represent some of the most common configurations of repmgr in production databases.

1 Primary + 1 Standby

1 Primary + 1 Standby

Here, repmgr is configured on Standby for failover in case the Primary node fails.

1 Primary + 2 Standbys

Here, repmgr is configured on 2 Standby nodes for failover in case the Primary node fails. Additional Standby node is configured for High Availability (HA) so at least one Standby is still present after failover.

1 Primary + 3 Standbys + 1 Witness

repmgr prevents Split Brain scenario for distributed servers. In case Location A become entirely unavailable and the Standby in Location B is a last resort, the Witness server ensures that the Standby at Location B does not promote itself to Primary.

Here, the Standby in Location B is a last resort in case Location A becomes entirely unavailable. The Witness server here ensures that in case of network interruption between the two locations, the Standby at Location B does not promote itself to Primary, i.e. prevents the Split Brain scenario.

License

repmgr is free and open-source software licensed under the GNU Public License (GPL) v3. This means you are free to use and modify repmgr as you see fit, however any modifications you make may only be distributed under the same terms. Click here for details.

Need more help?

Want to know even more? Need some help to implement repmgr? As the developers we’re the best people in the world to help you get up and running with repmgr. We have consultants available to provide assistance, plus our unique 24/7 Production Support subscription service also covers repmgr.

You can also raise your queries on repmgr’s Google group.

REPMGR Knowledge Base

Blogs

Aucune page ne correspond à votre recherche

Désolé, aucun article ne correspond à votre recherche

View All Blogs

Get in touch with us!

Please fill in the form below and we'll be in touch as soon as possible.

  • Twitter
  • Linkedin
  • Facebook
  • Youtube
  • Mail

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Faire défiler vers le haut
×