{"id":32787,"date":"2026-05-11T15:46:20","date_gmt":"2026-05-11T15:46:20","guid":{"rendered":"https:\/\/dev.indyli-services.com\/?p=32787"},"modified":"2026-05-11T15:55:09","modified_gmt":"2026-05-11T15:55:09","slug":"repliquer-avec-pgpool","status":"publish","type":"post","link":"https:\/\/dev.indyli-services.com\/?p=32787","title":{"rendered":"R\u00e9pliquer avec Pgpool"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"32787\" class=\"elementor elementor-32787\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6ffd280 e-con-full e-flex e-con e-parent\" data-id=\"6ffd280\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d4efacd elementor-widget elementor-widget-text-editor\" data-id=\"d4efacd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<div><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px; text-align: center;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000080; font-size: 18pt;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><u style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">INTRODUCTION<\/u><\/strong><\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Notre but aujourd\u2019hui est de nous approcher de la notion de cluster postgresql en haute disponibilit\u00e9.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Certaines infrastructures critiques n\u00e9cessitent de la haute disponibilit\u00e9. La base de donn\u00e9es est un point critique de toute application web. Pour garantir une qualit\u00e9 de service \u00e0 vos utilisateurs il peut \u00eatre int\u00e9ressant de mettre en place un cluster de bases de donn\u00e9es.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Nous allons nous int\u00e9resser plus pr\u00e9cis\u00e9ment \u00e0 la mise en place d\u2019une haute disponibilit\u00e9 pour PostgreSQL en utilisant l\u2019outil<\/span> <span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><a style=\"-webkit-tap-highlight-color: transparent; background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #017db6; cursor: pointer; transition-duration: 0.15s; transition-timing-function: ease-out; transition-property: color;\" href=\"http:\/\/www.pgpool.net\/\">Pgpool II<\/a>.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Pgpool est une application qui se place entre notre acc\u00e8s et PostgreSQL. Il permet notamment de faire la liaison entre les diff\u00e9rentes instances de PostgreSQL, tout en permettant de mettre en place de la r\u00e9plication, de la haute disponibilit\u00e9 et du load balancing.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Pgpool fonctionne par le principe de duplication de requ\u00eates pour g\u00e9rer la r\u00e9plication. Chaque \u00e9criture sur PostgreSQL sera effectu\u00e9e sur chaque serveur PostgreSQL du cluster.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Une fois la r\u00e9plication et load balancing mis en place, certaines requ\u00eates SELECT seront r\u00e9parties entre les diff\u00e9rents serveurs PostgreSQL. Voir la<\/span> <span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><a style=\"-webkit-tap-highlight-color: transparent; background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #017db6; cursor: pointer; transition-duration: 0.15s; transition-timing-function: ease-out; transition-property: color;\" href=\"http:\/\/www.pgpool.net\/docs\/latest\/pgpool-en.html\">documention Pgpool<\/a><\/span> <span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">pour conna\u00eetre les conditions de requ\u00eates en mode load balancing.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000;\">NB : Pgpool g\u00e8re nativement la haute disponibilit\u00e9 avec<\/span> <\/strong><a style=\"-webkit-tap-highlight-color: transparent; background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #017db6; cursor: pointer; transition-duration: 0.15s; transition-timing-function: ease-out; transition-property: color;\" href=\"http:\/\/www.pgpool.net\/docs\/pgpool-II-3.2.0\/wd-en.html\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">Watchdog<\/strong><\/a><\/span><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">.<\/span><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\"> Il nous permet de mettre en place une ip virtuelle, c\u2019est \u00e0 dire que les deux instances Pgpool vont se partager une ip unique qui pointera sur le Pgpool ayant le status <\/span><\/strong><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">master<\/strong><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">. Si le <\/strong><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">master<\/strong><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"> n\u2019est plus disponible, le serveur en <\/strong><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">standby<\/strong><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"> va prendre la place du <\/strong><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">master<\/strong><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"> et prendre aussi l\u2019ip virtuelle. Le but de cette ip virtuelle est d\u2019avoir un seul et m\u00eame point d\u2019entr\u00e9e dans le cluster.<\/strong><\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Nous pourrions \u00e9galement avoir une seule instance Pgpool, mais dans ce cas-ci nous nous exposons \u00e0 un<\/span> <span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><a style=\"-webkit-tap-highlight-color: transparent; background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #017db6; cursor: pointer; transition-duration: 0.15s; transition-timing-function: ease-out; transition-property: color;\" href=\"http:\/\/fr.wikipedia.org\/wiki\/Point_individuel_de_d%C3%A9faillance\">single point of failure<\/a>,<\/span><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"> car il n\u2019y a aucune redondance de Pgpool.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Dans cet exemple nous allons prendre le cas de deux serveurs h\u00e9bergeant chacun un serveur PostgreSQL. Nous allons pour cela r\u00e9pliquer les donn\u00e9es sur les deux serveurs, activer le load balancing et mettre en place la haute disponibilit\u00e9.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Le but de cette architecture est de pouvoir avoir acc\u00e9der \u00e0 nos donn\u00e9es m\u00eame si l\u2019un des deux serveurs n\u2019est plus accessible. Cette architecture est extensible car nous pouvons rajouter autant de serveurs que nous voulons \u00e0 notre cluster.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Voici les diff\u00e9rents points que nous allons aborder dans cet article :<\/span><\/p><ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">Illustration de l\u2019architecture finale<\/span><\/li><\/ul><p><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">Cr\u00e9ation de notre cluster:<\/span><\/p><p><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">Installation de PostgreSQL<\/span><\/p><p><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">Configuration de PostgreSQL<\/span><\/p><p><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">Mise en place de Pgpool<\/span><\/p><p><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">Haute disponibilit\u00e9 de notre cluster<\/span><\/p><p><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">Tests<\/span><\/p><ul><li style=\"list-style-type: none;\"><ul style=\"background: 0px 0px; border: 0px; margin: 0px; padding-left: 15px; vertical-align: baseline; outline: 0px; list-style-position: inside;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">R\u00e9plication<\/span><\/li><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">Haute disponibilit\u00e9<\/span><\/li><\/ul><\/li><\/ul><ol style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; padding: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">SCHEMAS<\/span><\/li><\/ol><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-949d804 e-flex e-con-boxed e-con e-parent\" data-id=\"949d804\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b43738a elementor-widget elementor-widget-image\" data-id=\"b43738a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"640\" height=\"394\" src=\"https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll1.png\" class=\"attachment-large size-large wp-image-32792\" alt=\"\" srcset=\"https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll1.png 768w, https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll1-300x185.png 300w, https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll1-600x370.png 600w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-859ba46 e-con-full e-flex e-con e-parent\" data-id=\"859ba46\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a65c31f elementor-widget elementor-widget-text-editor\" data-id=\"a65c31f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">2) MISE EN PLACE<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">A-) <\/strong><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">Installation des Paquets<\/strong><\/span><\/p><ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000000;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">Installer Postgres sur les deux serveurs.<\/strong><\/span><\/li><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000000;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">Installer les package suivant :<\/strong><\/span><\/li><\/ul><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">. apt-get install\u00a0 libpq-dev postgresql-serveur-dev-9.5 bison<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">. apt-get install postgresql-contrib-9.1 postgresql-doc-9.5 uuid libdbd-pg-perl<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">. apt-install pgpool2 libpgpool0\u00a0 (libpgpool\u201cz\u00e9ro\u201d)<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 B-)\u00a0\u00a0 Configuration de postgresql<\/strong><\/span><\/p><ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000000;\">Configuration de pg_hba.conf<\/span><\/li><\/ul><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"># Database administrative login by Unix domain socket<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">local\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0trust<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"># TYPE\u00a0 DATABASE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 USER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ADDRESS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 METHOD<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"># \u00ab local \u00bb is for Unix domain socket connections only<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">local\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 trust<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"># IPv4 local connections:<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">host\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 127.0.0.1\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 trust<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">host\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 0.0.0.0\/0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 trust<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"># IPv6 local connections:<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">host\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ::1\/128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 trust<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">host\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 0.0.0.0\/0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 trust<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"># Allow replication connections from localhost, by a user with the<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"># replication privilege.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">#local\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 peer<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">#host\u00a0\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 127.0.0.1\/32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">#host\u00a0\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ::1\/128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 md5<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">host\u00a0\u00a0\u00a0\u00a0 replication\u00a0\u00a0\u00a0\u00a0 all\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.0.0.0\/0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 trust<\/span><\/p><ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000000;\">Configuration du fichier postgresql.conf<\/span><\/li><\/ul><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">listen_addresses = \u2018*\u2019\u00a0 \u00a0# accepter toutes les connexions entrantes<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">wal_level = hot_standby\u00a0 \u00a0# mode permettant de passer Postgres en master avec des noeuds en standby<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">max_wal_senders = 2<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">wal_keep_segments = 50<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">hot_standby = on<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">archive_mode = on<\/span><\/p><ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000000;\">Ensuite on red\u00e9marre les service de postgresql ( \/etc\/init.d\/postgresql-9.5 restart )<\/span><\/li><\/ul><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">NB : cette configuration est effectu\u00e9e sur les deux serveurs postgres.<\/strong><\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\">\u00a0<\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">C-) CONFIGURATION DE Pgpool<\/strong><\/span><\/p><ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000000;\">Se connecter en tant que root et \u00e9diter le fichier pgpool.conf ( gedit \/etc\/pgpool2\/pgpool.conf)<\/span><\/li><\/ul><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Connection Serveur1 :<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Listing addres = \u2018* \u2018<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Port = 9999<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Backend_hostname0 = \u2018 adresse ip serveur1\u2019<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Backend_port0 = \u2018port de postgres sur le serveur1 (5432)\u2019<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Backend_weight0 = 1<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">\u2026.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">\u2026.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Backend_hostname1 = \u2018 adresse ip serveur2\u2019<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Backend_port0 = \u2018port de postgres sur le serveur2 (5432)\u2019<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Backend_weight1 = 1<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">\u2026..<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">\u2026..<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Replication_mode = true<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">\u2026<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">\u2026<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Load_balance_mode = true<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">\u2026<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">\u2026<\/span><\/p><ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000000;\">Puis on enregistre les modifications et on red\u00e9marre les services de pgpool2<\/span><\/li><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000000;\">Puis on saisit cette commande en tant que root: \u2013#\u00a0\u00a0 pgpool -n -n -f \/etc\/pgpool2\/pgpool.conf\u00a0\u00a0<\/span><\/li><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000000;\">Ensuite on arr\u00eate les service de pgpool ; puis on saisit cette commande<\/span><\/li><\/ul><ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000000;\">\u2013# pgpool -n -d -f \/etc\/pgpool2\/pgpool.conf\u00a0\u00a0 et on laisse (on ne touche rien) la configuration est termin\u00e9e sur pgpool<\/span><\/li><\/ul><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\">\u00a0<\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">D-) Test du client<\/strong><\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Sur son terminal en tant que root :<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">\u2013#\u00a0 createdb -h 192.168.0.4 -p 9999 -U postgres -d bdtest<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">La base de donn\u00e9es bdtest sera cr\u00e9er sur les deux serveur postgres.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">NB : la machine cliente doit avoir le client postgres installer (apt-get install postgresql-client-9.5).<\/span><\/p><p>\u00a0<\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px; text-align: center;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt; color: #000080;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><u style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">CONCLUSION<\/u><\/strong><\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Malgr\u00e9 les diff\u00e9rents probl\u00e8mes qu\u2019a pgpool il est n\u00e9ant moins efficace. Pour rem\u00e9dier \u00e0 un probl\u00e8me sur un des serveurs il faut r\u00e9soudre son probl\u00e8me et basculer le second en maitre sur pgpool et red\u00e9marrer pgpool. Apres remise \u00e0 jour du serveur en panne on doit le restaurer avec les donn\u00e9es du serveur \u00e0 partir du client pour que pgpool puisse le revoir comme une nouvelle base de donn\u00e9es. <\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>INTRODUCTION Notre but aujourd\u2019hui est de nous approcher de la notion de cluster postgresql en haute disponibilit\u00e9. Certaines infrastructures critiques n\u00e9cessitent de la haute disponibilit\u00e9. La base de donn\u00e9es est un point critique de toute application web. Pour garantir une &hellip; <\/p>\n","protected":false},"author":1,"featured_media":32788,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[87],"tags":[],"class_list":["post-32787","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriels"],"rttpg_featured_image_url":{"full":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1.png",768,520,false],"landscape":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1.png",768,520,false],"portraits":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1.png",768,520,false],"thumbnail":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1-150x150.png",150,150,true],"medium":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1-300x203.png",300,203,true],"large":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1.png",640,433,false],"1536x1536":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1.png",768,520,false],"2048x2048":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1.png",768,520,false],"course_thumbnail":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1-666x450.png",666,450,true],"woocommerce_thumbnail":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1-300x300.png",300,300,true],"woocommerce_single":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1-600x406.png",600,406,true],"woocommerce_gallery_thumbnail":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/pgpoll2-20-768x5201-1-100x100.png",100,100,true]},"rttpg_author":{"display_name":"admin","author_link":"https:\/\/dev.indyli-services.com\/?author=1"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/dev.indyli-services.com\/?cat=87\" rel=\"category\">Tutoriels<\/a>","rttpg_excerpt":"INTRODUCTION Notre but aujourd\u2019hui est de nous approcher de la notion de cluster postgresql en haute disponibilit\u00e9. Certaines infrastructures critiques n\u00e9cessitent de la haute disponibilit\u00e9. La base de donn\u00e9es est un point critique de toute application web. Pour garantir une &hellip;","_links":{"self":[{"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/posts\/32787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=32787"}],"version-history":[{"count":4,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/posts\/32787\/revisions"}],"predecessor-version":[{"id":32799,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/posts\/32787\/revisions\/32799"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/media\/32788"}],"wp:attachment":[{"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=32787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=32787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=32787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}