{"id":3208,"date":"2018-09-06T08:34:00","date_gmt":"2018-09-06T08:34:00","guid":{"rendered":"https:\/\/hoplasoftware.com\/?p=3208"},"modified":"2025-10-30T23:51:25","modified_gmt":"2025-10-30T22:51:25","slug":"integrando-pgpool-con-edb-postgres-failover-manager","status":"publish","type":"post","link":"https:\/\/hopla.tech\/en\/integrando-pgpool-con-edb-postgres-failover-manager\/","title":{"rendered":"Integrando PGpool con EDB Postgres Failover Manager"},"content":{"rendered":"<p><a style=\"color: #000000;\" href=\"https:\/\/www.enterprisedb.com\/\">EnterpriseDB,<\/a>&nbsp;entre las herramientas que proporciona a los clientes, cuenta con&nbsp;<a style=\"color: #000000;\" href=\"https:\/\/www.enterprisedb.com\/products\/edb-postgres-platform\/edb-postgres-failover-manager\">EDB Postgres Failover Manager<\/a>&nbsp;(EFM) para cubrir la alta disponibilidad del servicio de base de datos.&nbsp;<a style=\"color: #000000;\" href=\"https:\/\/www.enterprisedb.com\/products\/edb-postgres-platform\/edb-postgres-failover-manager\">EFM<\/a>, monitoriza el estado de los&nbsp;<em>clusters<\/em>&nbsp;de base de datos y act\u00faa en caso de error r\u00e1pidamente. Cuando se produce un error, puede promover un nodo esclavo a maestro, manteniendo la continuidad y rendimiento del servicio, as\u00ed como dando protecci\u00f3n ante posibles p\u00e9rdidas de informaci\u00f3n.<\/p>\n\n\n\n<p>Entre los \u00faltimos cambios integrados en&nbsp;<a style=\"color: #000000;\" href=\"https:\/\/www.enterprisedb.com\/products\/edb-postgres-platform\/edb-postgres-failover-manager\">EFM<\/a>&nbsp;versi\u00f3n 3 est\u00e1n, por un lado, m\u00faltiples&nbsp;<em>hooks<\/em>&nbsp;que nos permiten complementar las funcionalidades de&nbsp;<a style=\"color: #000000;\" href=\"https:\/\/www.enterprisedb.com\/products\/edb-postgres-platform\/edb-postgres-failover-manager\">EFM<\/a>&nbsp;con otras, y que ofrecen herramientas como&nbsp;<em>pgpool<\/em>.<\/p>\n\n\n\n<p>Por ejemplo, un caso muy com\u00fan en nuestros clientes, es la necesidad de ofrecer alta disponibilidad y balanceo de carga en el servicio de base de datos. Pero sin poder usar una IP virtual VIP,&nbsp;<strong>\u00bfentonces, qu\u00e9 opci\u00f3n tenemos?<\/strong>&nbsp;Utilizar la capacidad de balanceo de carga que nos ofrece&nbsp;<em>pgpool<\/em>&nbsp;y la alta disponibilidad la cubrimos con&nbsp;<a style=\"color: #000000;\" href=\"https:\/\/www.enterprisedb.com\/products\/edb-postgres-platform\/edb-postgres-failover-manager\">EFM<\/a>.&nbsp;<strong>\u00bfY c\u00f3mo hablan&nbsp;<a style=\"color: #000000;\" href=\"https:\/\/www.enterprisedb.com\/products\/edb-postgres-platform\/edb-postgres-failover-manager\">EFM<\/a>y&nbsp;<em>pgPool<\/em>?&nbsp;<\/strong>Mediante los siguientes propiedades de configuraci\u00f3n:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">script.load.balancer.attach=\nscript.load.balancer.detach=<\/pre>\n\n\n\n<p>Dentro del fichero de configuraci\u00f3n de&nbsp;<a style=\"color: #000000;\" href=\"https:\/\/www.enterprisedb.com\/products\/edb-postgres-platform\/edb-postgres-failover-manager\">EFM<\/a>, efm.properties, podremos definir dichas propiedades. Con estos&nbsp;<em>hooks<\/em>, ser\u00e1 m\u00e1s sencillo soportar casos como el&nbsp;<em>switchover<\/em>, fallo en alg\u00fan esclavo, o fallo del maestro que no termine con una correcta promoci\u00f3n.<\/p>\n\n\n\n<p>Para conocer un poco m\u00e1s de cada una de estas propiedades, vamos a detallar los casos de error que contemplan cada una. Para el&nbsp;<em>hook<\/em>&nbsp;de&nbsp;<em>detach<\/em>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Despu\u00e9s del fallo de una base de datos.<\/strong>\u00a0El\u00a0<em>script<\/em>\u00a0ser\u00e1 invocado por el agente local a la base de datos que ha fallado.<\/li>\n\n\n\n<li><strong>Despu\u00e9s del fallo en un nodo de base de datos.<\/strong>\u00a0En este caso, otro agente ser\u00e1 el responsable de llamar al\u00a0<em>script<\/em>, pas\u00e1ndole la ip\/hostname del nodo con error como par\u00e1metro. Como es otro agente el que llama al\u00a0<em>script<\/em>\u00a0de\u00a0<em>detach<\/em>, es importante que todos los nodos que pertenecen al\u00a0<em>cluster<\/em>\u00a0EFM tengan una copia de los scripts.<\/li>\n\n\n\n<li>Cuando el agente del maestro detecta que \u00e9ste se ha quedado a<strong>islado de la mayor\u00eda de nodos del cluster<\/strong>. En este caso, el agente del maestro, no puede contactar con el balanceador de carga, pero de todas formas lo intentar\u00e1. \u00a0Para el resto de miembros del\u00a0<em>cluster<\/em>, \u00e9ste ser\u00e1 un caso de fallo en un nodo de base de datos y se actuar\u00e1 tal como se explicaba en el caso anterior.<\/li>\n<\/ul>\n\n\n\n<p>En resumen, cualquier condici\u00f3n que pudiera causar que el agente del maestro o esclavos entre en modo \u2018IDLE\u2019, o si el resto de miembros del&nbsp;<em>cluster<\/em>&nbsp;detecta que un nodo desaparece, entonces el&nbsp;<em>script<\/em>&nbsp;de \u2018<em>detach<\/em>\u2019 ser\u00e1 llamado.<\/p>\n\n\n\n<p>Los casos que ser\u00e1n contemplados por el&nbsp;<em>hook<\/em>&nbsp;de \u2018<em>attach<\/em>\u2019 son:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Una promoci\u00f3n de un nodo que se convierta en maestro. Este es el caso en el que cualquier esclavo se convierte en maestro, ya sea por un\u00a0<em>failover<\/em>, una promoci\u00f3n manual o la ejecuci\u00f3n de un\u00a0<em>switchover<\/em>.<\/li>\n\n\n\n<li>Un agente en estado \u2018IDLE\u2019 reanuda la monitorizaci\u00f3n de la base de datos maestra o esclava, despu\u00e9s de un fallo. Esto ocurre cuando un fallo en la base de datos ha sido corregido o se ha reiniciado, y el agente vuelve a monitorizar el estado, despu\u00e9s de ejecutarse el comando\u00a0<i>efm resume<\/i>\u00a0o ha pasado el periodo definido en la propiedad auto.resume.period.<\/li>\n\n\n\n<li>Un agente en estado \u2018IDLE\u2019 vuelve a monitorizar despu\u00e9s del arranque. Un ejemplo de este caso es cuando se enciende un nodo, efm arranca, la base de datos arranca y al agente de efm se le indica que vuelva a monitorizar el\u00a0<em>cluster<\/em>. La base de datos a\u00fan no est\u00e1 disponible para el balanceador porque no estaba funcionando previamente.<\/li>\n\n\n\n<li>Un agente \u2018IDLE\u2019 vuelve a monitorizar la base de datos maestra original que ha sido reiniciada como esclava despu\u00e9s de un switchover.<\/li>\n<\/ul>\n\n\n\n<p>Resumiendo, cualquier condici\u00f3n que cause que un agente pase a estado \u2018IDLE\u2019 o promocione para ser convertido en maestro o esclavo, &nbsp;llamar\u00e1 al script de \u2018<em>attach<\/em>\u2019.<\/p>\n\n\n\n<p>Para ver un caso real, vamos a partir de un nodo de base de datos que tenga asociada la ip 10.0.100.10 y con la siguiente configuraci\u00f3n:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">script.load.balancer.attach=\/somepath\/attach_script.sh %h\nscript.load.balancer.detach=\/somepath\/detach_script.sh %h<\/pre>\n\n\n\n<p>Si la base de datos en el nodo se para, lo siguiente ser\u00eda ejecutado por el usuario bajo el que funciona Failover Manager ( generalmente el usuario \u2018efm\u2019), pas\u00e1ndole la direcci\u00f3n IP al nodo de base de datos que debiera ser eliminado de la configuraci\u00f3n del balanceador:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/somepath\/detach_script.sh 10.0.100.10<\/pre>\n\n\n\n<p>Tambi\u00e9n podemos definir los&nbsp;<em>hooks<\/em>&nbsp;de&nbsp;<em>attach<\/em>&nbsp;y&nbsp;<em>detach&nbsp;<\/em>con un mismo&nbsp;<em>script<\/em>, incluyendo un par\u00e1metro adicional donde se especifica si la acci\u00f3n es de&nbsp;<em>attachment<\/em>&nbsp;o&nbsp;<em>detachment<\/em>&nbsp;del nodo:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">script.load.balancer.attach=\/somepath\/lb_script.sh attach %h\nscript.load.balancer.detach=\/somepath\/lb_script.sh detach %h<\/pre>\n\n\n\n<p>En este caso, la instrucci\u00f3n que el agente de EFM ejecutar\u00eda ser\u00eda:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/somepath\/lb_script.sh detach 10.0.100.10<\/pre>\n\n\n\n<p>Si un nodo falla, entonces otro nodo llamar\u00eda a su&nbsp;<em>script<\/em>&nbsp;de&nbsp;<em>detach<\/em>&nbsp;local, tal como se muestra arriba, pas\u00e1ndole la direcci\u00f3n IP del nodo que fall\u00f3. As\u00ed es porque es importante que todo nodo de EFM tenga una copia o acceso a los scripts de attach\/detach si utilizamos los nuevos hooks para integrar EFM con balanceadores.<\/p>\n\n\n\n<p>Puedes encontrar el contenido original&nbsp;<a style=\"color: #000000;\" href=\"https:\/\/www.enterprisedb.com\/blog\/load-balancer-script-hooks-efm-3-2\">aqu\u00ed<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>EnterpriseDB,&nbsp;entre las herramientas que proporciona a los clientes, cuenta con&nbsp;EDB Postgres Failover Manager&nbsp;(EFM) para cubrir la alta disponibilidad del servicio de base de datos.&nbsp;EFM, monitoriza el estado de los&nbsp;clusters&nbsp;de base de datos y act\u00faa en caso de error r\u00e1pidamente. Cuando se produce un error, puede promover un nodo esclavo a maestro, manteniendo la continuidad y [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":11880,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[285],"tags":[627,753,755,751,700,757,752,756,754],"class_list":["post-3208","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-intelligence-platform","tag-alta-disponibilidad-ha","tag-balanceo-de-carga","tag-cluster-postgresql","tag-edb-postgres-failover-manager-efm","tag-enterprisedb-edb","tag-monitorizacion-de-cluster","tag-pgpool","tag-sin-ip-virtual-vip-less","tag-switchover-y-failover"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Integrando PGpool con EDB Postgres Failover Manager | Hopla! Tech<\/title>\n<meta name=\"description\" content=\"Integrando PGpool con EDB Postgres Failover Manager Transformaci\u00f3n digital, modernizaci\u00f3n de aplicaciones, Open Spource, soporte Postgres\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hopla.tech\/en\/integrando-pgpool-con-edb-postgres-failover-manager\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integrando PGpool con EDB Postgres Failover Manager\" \/>\n<meta property=\"og:description\" content=\"Integrando PGpool con EDB Postgres Failover Manager Transformaci\u00f3n digital, modernizaci\u00f3n de aplicaciones, Open Spource, soporte Postgres\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hopla.tech\/en\/integrando-pgpool-con-edb-postgres-failover-manager\/\" \/>\n<meta property=\"og:site_name\" content=\"Hopla! Tech\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-06T08:34:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-30T22:51:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/introducing-edb-failover-manager-3-638.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Hopla!\u00a0Tech\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@HoplaSoftware\" \/>\n<meta name=\"twitter:site\" content=\"@HoplaSoftware\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hopla!\u00a0Tech\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/\"},\"author\":{\"name\":\"Hopla!\u00a0Tech\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/#\\\/schema\\\/person\\\/9cf81e385f7a2f68085449a2e16e1d22\"},\"headline\":\"Integrando PGpool con EDB Postgres Failover Manager\",\"datePublished\":\"2018-09-06T08:34:00+00:00\",\"dateModified\":\"2025-10-30T22:51:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/\"},\"wordCount\":933,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/introducing-edb-failover-manager-3-638.webp\",\"keywords\":[\"alta disponibilidad (HA)\",\"balanceo de carga\",\"cl\u00faster PostgreSQL\",\"EDB Postgres Failover Manager (EFM)\",\"EnterpriseDB (EDB)\",\"monitorizaci\u00f3n de cl\u00faster\",\"pgpool\",\"sin IP virtual (VIP-less)\",\"switchover y failover\"],\"articleSection\":[\"Data Intelligence Platform\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/\",\"url\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/\",\"name\":\"Integrando PGpool con EDB Postgres Failover Manager | Hopla! Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/introducing-edb-failover-manager-3-638.webp\",\"datePublished\":\"2018-09-06T08:34:00+00:00\",\"dateModified\":\"2025-10-30T22:51:25+00:00\",\"description\":\"Integrando PGpool con EDB Postgres Failover Manager Transformaci\u00f3n digital, modernizaci\u00f3n de aplicaciones, Open Spource, soporte Postgres\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/introducing-edb-failover-manager-3-638.webp\",\"contentUrl\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/introducing-edb-failover-manager-3-638.webp\",\"width\":500,\"height\":375},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/integrando-pgpool-con-edb-postgres-failover-manager\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/hopla.tech\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Integrando PGpool con EDB Postgres Failover Manager\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/#website\",\"url\":\"https:\\\/\\\/hopla.tech\\\/\",\"name\":\"Hopla! Tech\",\"description\":\"The enterprise software and consultancy company\",\"publisher\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/#organization\"},\"alternateName\":\"Hopla!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hopla.tech\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/#organization\",\"name\":\"Hopla! Tech\",\"alternateName\":\"Hopla!\",\"url\":\"https:\\\/\\\/hopla.tech\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/Hopla-by-BTW-b-3.webp\",\"contentUrl\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/Hopla-by-BTW-b-3.webp\",\"width\":274,\"height\":115,\"caption\":\"Hopla! Tech\"},\"image\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/HoplaSoftware\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/hopla-software\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@hoplasoftware7485\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/#\\\/schema\\\/person\\\/9cf81e385f7a2f68085449a2e16e1d22\",\"name\":\"Hopla!\u00a0Tech\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/74a9053adf21148080273a18b879a3392f96e141e511a337179a4438f6bde966?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/74a9053adf21148080273a18b879a3392f96e141e511a337179a4438f6bde966?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/74a9053adf21148080273a18b879a3392f96e141e511a337179a4438f6bde966?s=96&d=mm&r=g\",\"caption\":\"Hopla!\u00a0Tech\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Integrando PGpool con EDB Postgres Failover Manager | Hopla! Tech","description":"Integrando PGpool con EDB Postgres Failover Manager Transformaci\u00f3n digital, modernizaci\u00f3n de aplicaciones, Open Spource, soporte Postgres","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hopla.tech\/en\/integrando-pgpool-con-edb-postgres-failover-manager\/","og_locale":"en_GB","og_type":"article","og_title":"Integrando PGpool con EDB Postgres Failover Manager","og_description":"Integrando PGpool con EDB Postgres Failover Manager Transformaci\u00f3n digital, modernizaci\u00f3n de aplicaciones, Open Spource, soporte Postgres","og_url":"https:\/\/hopla.tech\/en\/integrando-pgpool-con-edb-postgres-failover-manager\/","og_site_name":"Hopla! Tech","article_published_time":"2018-09-06T08:34:00+00:00","article_modified_time":"2025-10-30T22:51:25+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/introducing-edb-failover-manager-3-638.webp","type":"image\/webp"}],"author":"Hopla!\u00a0Tech","twitter_card":"summary_large_image","twitter_creator":"@HoplaSoftware","twitter_site":"@HoplaSoftware","twitter_misc":{"Written by":"Hopla!\u00a0Tech","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/#article","isPartOf":{"@id":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/"},"author":{"name":"Hopla!\u00a0Tech","@id":"https:\/\/hopla.tech\/#\/schema\/person\/9cf81e385f7a2f68085449a2e16e1d22"},"headline":"Integrando PGpool con EDB Postgres Failover Manager","datePublished":"2018-09-06T08:34:00+00:00","dateModified":"2025-10-30T22:51:25+00:00","mainEntityOfPage":{"@id":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/"},"wordCount":933,"commentCount":0,"publisher":{"@id":"https:\/\/hopla.tech\/#organization"},"image":{"@id":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/#primaryimage"},"thumbnailUrl":"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/introducing-edb-failover-manager-3-638.webp","keywords":["alta disponibilidad (HA)","balanceo de carga","cl\u00faster PostgreSQL","EDB Postgres Failover Manager (EFM)","EnterpriseDB (EDB)","monitorizaci\u00f3n de cl\u00faster","pgpool","sin IP virtual (VIP-less)","switchover y failover"],"articleSection":["Data Intelligence Platform"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/","url":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/","name":"Integrando PGpool con EDB Postgres Failover Manager | Hopla! Tech","isPartOf":{"@id":"https:\/\/hopla.tech\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/#primaryimage"},"image":{"@id":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/#primaryimage"},"thumbnailUrl":"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/introducing-edb-failover-manager-3-638.webp","datePublished":"2018-09-06T08:34:00+00:00","dateModified":"2025-10-30T22:51:25+00:00","description":"Integrando PGpool con EDB Postgres Failover Manager Transformaci\u00f3n digital, modernizaci\u00f3n de aplicaciones, Open Spource, soporte Postgres","breadcrumb":{"@id":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/#primaryimage","url":"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/introducing-edb-failover-manager-3-638.webp","contentUrl":"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/introducing-edb-failover-manager-3-638.webp","width":500,"height":375},{"@type":"BreadcrumbList","@id":"https:\/\/hopla.tech\/integrando-pgpool-con-edb-postgres-failover-manager\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/hopla.tech\/"},{"@type":"ListItem","position":2,"name":"Integrando PGpool con EDB Postgres Failover Manager"}]},{"@type":"WebSite","@id":"https:\/\/hopla.tech\/#website","url":"https:\/\/hopla.tech\/","name":"Hopla! Tech","description":"The enterprise software and consultancy company","publisher":{"@id":"https:\/\/hopla.tech\/#organization"},"alternateName":"Hopla!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hopla.tech\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/hopla.tech\/#organization","name":"Hopla! Tech","alternateName":"Hopla!","url":"https:\/\/hopla.tech\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/hopla.tech\/#\/schema\/logo\/image\/","url":"https:\/\/hopla.tech\/wp-content\/uploads\/2025\/12\/Hopla-by-BTW-b-3.webp","contentUrl":"https:\/\/hopla.tech\/wp-content\/uploads\/2025\/12\/Hopla-by-BTW-b-3.webp","width":274,"height":115,"caption":"Hopla! Tech"},"image":{"@id":"https:\/\/hopla.tech\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/HoplaSoftware","https:\/\/www.linkedin.com\/company\/hopla-software\/","https:\/\/www.youtube.com\/@hoplasoftware7485"]},{"@type":"Person","@id":"https:\/\/hopla.tech\/#\/schema\/person\/9cf81e385f7a2f68085449a2e16e1d22","name":"Hopla!\u00a0Tech","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/74a9053adf21148080273a18b879a3392f96e141e511a337179a4438f6bde966?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/74a9053adf21148080273a18b879a3392f96e141e511a337179a4438f6bde966?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/74a9053adf21148080273a18b879a3392f96e141e511a337179a4438f6bde966?s=96&d=mm&r=g","caption":"Hopla!\u00a0Tech"}}]}},"_links":{"self":[{"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/posts\/3208","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/comments?post=3208"}],"version-history":[{"count":2,"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/posts\/3208\/revisions"}],"predecessor-version":[{"id":12017,"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/posts\/3208\/revisions\/12017"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/media\/11880"}],"wp:attachment":[{"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/media?parent=3208"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/categories?post=3208"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/tags?post=3208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}