{"id":6713,"date":"2020-01-14T09:35:08","date_gmt":"2020-01-14T08:35:08","guid":{"rendered":"https:\/\/www.credativ.de\/blog\/credativ-inside\/debian-integration-of-patroni-and-vip-manager\/"},"modified":"2022-03-28T17:36:16","modified_gmt":"2022-03-28T15:36:16","slug":"debian-integration-of-patroni-and-vip-manager","status":"publish","type":"post","link":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/","title":{"rendered":"Debian integration of Patroni and vip-manager"},"content":{"rendered":"<p>Patroni is a clustering solution for PostgreSQL<sup>\u00ae<\/sup> that is getting more and more popular in the cloud and Kubernetes sector due to its operator pattern and integration with Etcd or Consul. Some time ago we wrote a <a href=\"https:\/\/www.credativ.de\/en\/blog\/howtos\/integrating-patroni-into-debian\/\">blog post<\/a> about the integration of Patroni into Debian. Recently, the <a href=\"https:\/\/github.com\/cybertec-postgresql\/vip-manager\" target=\"_blank\" rel=\"noopener noreferrer\">vip-manager<\/a> project which is closely related to Patroni has been uploaded to Debian by us. We will present vip-manager and how we integrated it into Debian in the following.<\/p>\n<p>To recap, Patroni uses a distributed consensus store (DCS) for leader-election and failover. The current cluster leader periodically updates its leader-key in the DCS. As soon the key cannot be updated by Patroni for whatever reason it becomes stale. A new leader election is then initiated among the remaining cluster nodes.<\/p>\n<h2>PostgreSQL Client-Solutions for High-Availability<\/h2>\n<p>From the user\u2019s point of view it needs to be ensured that the application is always connected to the leader, as no write transactions are possible on the read-only standbys. Conventional high-availability solutions like Pacemaker utilize virtual IPs (VIPs) that are moved to the primary node in the case of a failover.<\/p>\n<p>For Patroni, such a mechanism did not exist so far. Usually, HAProxy (or a similar solution) is used which does periodic health-checks on each node\u2019s Patroni REST-API and routes the client requests to the current leader.<\/p>\n<p>An alternative is client-based failover (which is available since PostgreSQL 10), where all cluster members are configured in the client connection string. After a connection failure the client tries each remaining cluster member in turn until it reaches a new primary.<\/p>\n<h2>vip-manager<\/h2>\n<p>A new and comfortable approach to client failover is vip-manager. It is a service written in Go that gets started on all cluster nodes and connects to the DCS. If the local node owns the leader-key, vip-manager starts the configured VIP. In case of a failover, vip-manager removes the VIP on the old leader and the corresponding service on the new leader starts it there. The clients are configured for the VIP and will always connect to the cluster leader.<\/p>\n<h2>Debian-Integration of vip-manager<\/h2>\n<p>For Debian, the <code>pg_createconfig_patroni<\/code> program from the Patroni package has been adapted so that it can now create a vip-manager configuration:<\/p>\n<pre><code>pg_createconfig_patroni 11 test --vip=10.0.3.2\r\n<\/code><\/pre>\n<p>Similar to Patroni, we start the service for each instance:<\/p>\n<pre><code>systemctl start vip-manager@11-test\r\n<\/code><\/pre>\n<p>The output of <code>patronictl<\/code> shows that <code>pg1<\/code> is the leader:<\/p>\n<pre><code>+---------+--------+------------+--------+---------+----+-----------+\r\n| Cluster | Member |    Host    |  Role  |  State  | TL | Lag in MB |\r\n+---------+--------+------------+--------+---------+----+-----------+\r\n| 11-test |  pg1   | 10.0.3.247 | Leader | running |  1 |           |\r\n| 11-test |  pg2   | 10.0.3.94  |        | running |  1 |         0 |\r\n| 11-test |  pg3   | 10.0.3.214 |        | running |  1 |         0 |\r\n+---------+--------+------------+--------+---------+----+-----------+\r\n<\/code><\/pre>\n<p>In journal of \u2018pg1\u2019 it can be seen that the VIP has been configured:<\/p>\n<pre><code>Jan 19 14:53:38 pg1 vip-manager[9314]: 2020\/01\/19 14:53:38 IP address 10.0.3.2\/24 state is false, desired true\r\nJan 19 14:53:38 pg1 vip-manager[9314]: 2020\/01\/19 14:53:38 Configuring address 10.0.3.2\/24 on eth0\r\nJan 19 14:53:38 pg1 vip-manager[9314]: 2020\/01\/19 14:53:38 IP address 10.0.3.2\/24 state is true, desired true\r\n<\/code><\/pre>\n<p>If LXC containers are used, one can also see the VIP in the output of <code>lxc-ls -f<\/code>:<\/p>\n<pre><code>NAME    STATE   AUTOSTART GROUPS IPV4                 IPV6 UNPRIVILEGED\r\npg1     RUNNING 0         -      10.0.3.2, 10.0.3.247 -    false\r\npg2     RUNNING 0         -      10.0.3.94            -    false\r\npg3     RUNNING 0         -      10.0.3.214           -    false\r\n<\/code><\/pre>\n<p>The vip-manager packages are available for Debian testing (<code>bullseye<\/code>) and unstable, as well as for the upcoming 20.04 LTS Ubuntu release (<code>focal<\/code>) in the official repositories. For Debian stable (<code>buster<\/code>), as well as for Ubuntu 19.04 and 19.10, packages are available at <code>apt.postgresql.org<\/code> maintained by credativ, along with the updated Patroni packages with vip-manager integration.<\/p>\n<h2>Switchover Behaviour<\/h2>\n<p>In case of a planned switchover, e.g. <code>pg2<\/code> becomes the new leader:<\/p>\n<pre><code># patronictl -c \/etc\/patroni\/11-test.yml switchover --master pg1 --candidate pg2 --force\r\nCurrent cluster topology\r\n+---------+--------+------------+--------+---------+----+-----------+\r\n| Cluster | Member |    Host    |  Role  |  State  | TL | Lag in MB |\r\n+---------+--------+------------+--------+---------+----+-----------+\r\n| 11-test |  pg1   | 10.0.3.247 | Leader | running |  1 |           |\r\n| 11-test |  pg2   | 10.0.3.94  |        | running |  1 |         0 |\r\n| 11-test |  pg3   | 10.0.3.214 |        | running |  1 |         0 |\r\n+---------+--------+------------+--------+---------+----+-----------+\r\n2020-01-19 15:35:32.52642 Successfully switched over to &quot;pg2&quot;\r\n+---------+--------+------------+--------+---------+----+-----------+\r\n| Cluster | Member |    Host    |  Role  |  State  | TL | Lag in MB |\r\n+---------+--------+------------+--------+---------+----+-----------+\r\n| 11-test |  pg1   | 10.0.3.247 |        | stopped |    |   unknown |\r\n| 11-test |  pg2   | 10.0.3.94  | Leader | running |  1 |           |\r\n| 11-test |  pg3   | 10.0.3.214 |        | running |  1 |         0 |\r\n+---------+--------+------------+--------+---------+----+-----------+\r\n<\/code><\/pre>\n<p>The VIP has now been moved to the new leader:<\/p>\n<pre><code>NAME    STATE   AUTOSTART GROUPS IPV4                 IPV6 UNPRIVILEGED\r\npg1     RUNNING 0         -      10.0.3.247          -    false\r\npg2     RUNNING 0         -      10.0.3.2, 10.0.3.94 -    false\r\npg3     RUNNING 0         -      10.0.3.214          -    false\r\n<\/code><\/pre>\n<p>This can also be seen in the journals, both from the old leader:<\/p>\n<pre><code>Jan 19 15:35:31 pg1 patroni[9222]: 2020-01-19 15:35:31,634 INFO: manual failover: demoting myself\r\nJan 19 15:35:31 pg1 patroni[9222]: 2020-01-19 15:35:31,854 INFO: Leader key released\r\nJan 19 15:35:32 pg1 vip-manager[9314]: 2020\/01\/19 15:35:32 IP address 10.0.3.2\/24 state is true, desired false\r\nJan 19 15:35:32 pg1 vip-manager[9314]: 2020\/01\/19 15:35:32 Removing address 10.0.3.2\/24 on eth0\r\nJan 19 15:35:32 pg1 vip-manager[9314]: 2020\/01\/19 15:35:32 IP address 10.0.3.2\/24 state is false, desired false\r\n<\/code><\/pre>\n<p>As well as from the new leader <code>pg2<\/code>:<\/p>\n<pre><code>Jan 19 15:35:31 pg2 patroni[9229]: 2020-01-19 15:35:31,881 INFO: promoted self to leader by acquiring session lock\r\nJan 19 15:35:31 pg2 vip-manager[9292]: 2020\/01\/19 15:35:31 IP address 10.0.3.2\/24 state is false, desired true\r\nJan 19 15:35:31 pg2 vip-manager[9292]: 2020\/01\/19 15:35:31 Configuring address 10.0.3.2\/24 on eth0\r\nJan 19 15:35:31 pg2 vip-manager[9292]: 2020\/01\/19 15:35:31 IP address 10.0.3.2\/24 state is true, desired true\r\nJan 19 15:35:32 pg2 patroni[9229]: 2020-01-19 15:35:32,923 INFO: Lock owner: pg2; I am pg2\r\n<\/code><\/pre>\n<p>As one can see, the VIP is moved within one second.<\/p>\n<h2>Updated Ansible Playbook<\/h2>\n<p>Our <a href=\"https:\/\/github.com\/credativ\/ansible-playbook-patroni-debian\" target=\"_blank\" rel=\"noopener noreferrer\">Ansible-Playbook<\/a> for the automated setup of a three-node cluster on Debian has also been updated and can now configure a VIP if so desired:<\/p>\n<pre><code># ansible-playbook -i inventory -e vip=10.0.3.2 patroni.yml\r\n<\/code><\/pre>\n<h2>Questions and Help<\/h2>\n<p>Do you have any questions or need help? Feel free to write to info@credativ.com.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Patroni is a clustering solution for PostgreSQL\u00ae that is getting more and more popular in the cloud and Kubernetes sector due to its operator pattern and integration with Etcd or Consul. Some time ago we wrote a blog post about the integration of Patroni into Debian. Recently, the vip-manager project which is closely related to [&hellip;]<\/p>\n","protected":false},"author":37,"featured_media":4083,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1885,1708],"tags":[1775,1798,1801],"class_list":["post-6713","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-howtos-en","category-postgresql-en","tag-debian-en","tag-patroni-en","tag-postgresql-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.6 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Debian integration of Patroni and vip-manager - credativ\u00ae<\/title>\n<meta name=\"description\" content=\"Patroni is a cluster solution for PostgreSQL\u00ae that is becoming increasingly popular, especially in the cloud and Kubernetes environments.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Debian integration of Patroni and vip-manager\" \/>\n<meta property=\"og:description\" content=\"Patroni is a cluster solution for PostgreSQL\u00ae that is becoming increasingly popular, especially in the cloud and Kubernetes environments.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/\" \/>\n<meta property=\"og:site_name\" content=\"credativ\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/credativDE\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-14T08:35:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-28T15:36:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.credativ.de\/wp-content\/uploads\/2020\/01\/Debian-Integration-von-Patroni-und-vip-manager-Header.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2500\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michael Banck\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@credativde\" \/>\n<meta name=\"twitter:site\" content=\"@credativde\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Banck\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/\"},\"author\":{\"name\":\"Michael Banck\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#\\\/schema\\\/person\\\/038c79105ce9b5fd885631da3f806698\"},\"headline\":\"Debian integration of Patroni and vip-manager\",\"datePublished\":\"2020-01-14T08:35:08+00:00\",\"dateModified\":\"2022-03-28T15:36:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/\"},\"wordCount\":569,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Debian-Integration-von-Patroni-und-vip-manager-Header.jpg\",\"keywords\":[\"Debian\",\"Patroni\",\"PostgreSQL\u00ae\"],\"articleSection\":[\"HowTos\",\"PostgreSQL\u00ae\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#respond\"]}],\"copyrightYear\":\"2020\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/\",\"url\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/\",\"name\":\"Debian integration of Patroni and vip-manager - credativ\u00ae\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Debian-Integration-von-Patroni-und-vip-manager-Header.jpg\",\"datePublished\":\"2020-01-14T08:35:08+00:00\",\"dateModified\":\"2022-03-28T15:36:16+00:00\",\"description\":\"Patroni is a cluster solution for PostgreSQL\u00ae that is becoming increasingly popular, especially in the cloud and Kubernetes environments.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Debian-Integration-von-Patroni-und-vip-manager-Header.jpg\",\"contentUrl\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Debian-Integration-von-Patroni-und-vip-manager-Header.jpg\",\"width\":2500,\"height\":300,\"caption\":\"Debian-Integration von Patroni und vip-manager Header\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Debian integration of Patroni and vip-manager\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/\",\"name\":\"credativ GmbH\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Organization\",\"Place\"],\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#organization\",\"name\":\"credativ\u00ae\",\"url\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/\",\"logo\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#local-main-organization-logo\"},\"image\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#local-main-organization-logo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/credativDE\\\/\",\"https:\\\/\\\/x.com\\\/credativde\",\"https:\\\/\\\/mastodon.social\\\/@credativde\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/credativ-gmbh\",\"https:\\\/\\\/www.instagram.com\\\/credativ\\\/\"],\"description\":\"Die credativ GmbH ist ein f\u00fchrendes, auf Open Source Software spezialisiertes IT-Dienstleistungs- und Beratungsunternehmen. Wir bieten umfassende und professionelle Services, von Beratung und Infrastruktur-Betrieb \u00fcber 24\\\/7 Support bis hin zu individuellen L\u00f6sungen und Schulungen. Unser Fokus liegt auf dem ganzheitlichen Management von gesch\u00e4ftskritischen Open-Source-Systemen, darunter Betriebssysteme (z.B. Linux), Datenbanken (z.B. PostgreSQL), Konfigurationsmanagement (z.B. Ansible, Puppet) und Virtualisierung. Als engagierter Teil der Open-Source-Community unterst\u00fctzen wir unsere Kunden dabei, die Vorteile freier Software sicher, stabil und effizient in ihrer IT-Umgebung zu nutzen.\",\"legalName\":\"credativ GmbH\",\"foundingDate\":\"2025-03-01\",\"duns\":\"316387060\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"},\"address\":{\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#local-main-place-address\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":\"51.1732374\",\"longitude\":\"6.392010099999999\"},\"telephone\":[\"+4921619174200\",\"08002733284\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"telephone\":\"08002733284\",\"email\":\"vertrieb@credativ.de\"},\"openingHoursSpecification\":[{\"@type\":\"OpeningHoursSpecification\",\"dayOfWeek\":[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"],\"opens\":\"09:00\",\"closes\":\"17:00\"},{\"@type\":\"OpeningHoursSpecification\",\"dayOfWeek\":[\"Saturday\",\"Sunday\"],\"opens\":\"00:00\",\"closes\":\"00:00\"}],\"email\":\"info@credativ.de\",\"areaServed\":\"D-A-CH\",\"vatID\":\"DE452151696\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/#\\\/schema\\\/person\\\/038c79105ce9b5fd885631da3f806698\",\"name\":\"Michael Banck\",\"description\":\"Michael Banck ist seit 2009 Mitarbeiter der credativ GmbH, sowie seit 2001 Mitglied des Debian Projekts und auch in weiteren Open Source Projekten aktiv. Als Mitglied des Datenbank-Teams von credativ hat er in den letzten Jahren verschiedene Kunden bei der L\u00f6sung von Problemen mit und dem t\u00e4glichen Betrieb von PostgreSQL\u00ae, sowie bei der Einf\u00fchrung von Hochverf\u00fcgbarkeits-L\u00f6sungen im Bereich Datenbanken unterst\u00fctzt und beraten.\"},{\"@type\":\"PostalAddress\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#local-main-place-address\",\"streetAddress\":\"Hennes-Weisweiler-Allee 23\",\"addressLocality\":\"M\u00f6nchengladbach\",\"postalCode\":\"41179\",\"addressRegion\":\"Deutschland\",\"addressCountry\":\"DE\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.credativ.de\\\/en\\\/blog\\\/postgresql\\\/debian-integration-of-patroni-and-vip-manager\\\/#local-main-organization-logo\",\"url\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/credativ-logo-right.svg\",\"contentUrl\":\"https:\\\/\\\/www.credativ.de\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/credativ-logo-right.svg\",\"caption\":\"credativ\u00ae\"}]}<\/script>\n<meta name=\"geo.placename\" content=\"M\u00f6nchengladbach\" \/>\n<meta name=\"geo.position\" content=\"51.1732374;6.392010099999999\" \/>\n<meta name=\"geo.region\" content=\"Germany\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Debian integration of Patroni and vip-manager - credativ\u00ae","description":"Patroni is a cluster solution for PostgreSQL\u00ae that is becoming increasingly popular, especially in the cloud and Kubernetes environments.","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:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/","og_locale":"en_US","og_type":"article","og_title":"Debian integration of Patroni and vip-manager","og_description":"Patroni is a cluster solution for PostgreSQL\u00ae that is becoming increasingly popular, especially in the cloud and Kubernetes environments.","og_url":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/","og_site_name":"credativ\u00ae","article_publisher":"https:\/\/www.facebook.com\/credativDE\/","article_published_time":"2020-01-14T08:35:08+00:00","article_modified_time":"2022-03-28T15:36:16+00:00","og_image":[{"width":2500,"height":300,"url":"https:\/\/www.credativ.de\/wp-content\/uploads\/2020\/01\/Debian-Integration-von-Patroni-und-vip-manager-Header.jpg","type":"image\/jpeg"}],"author":"Michael Banck","twitter_card":"summary_large_image","twitter_creator":"@credativde","twitter_site":"@credativde","twitter_misc":{"Written by":"Michael Banck","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#article","isPartOf":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/"},"author":{"name":"Michael Banck","@id":"https:\/\/www.credativ.de\/en\/#\/schema\/person\/038c79105ce9b5fd885631da3f806698"},"headline":"Debian integration of Patroni and vip-manager","datePublished":"2020-01-14T08:35:08+00:00","dateModified":"2022-03-28T15:36:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/"},"wordCount":569,"commentCount":0,"publisher":{"@id":"https:\/\/www.credativ.de\/en\/#organization"},"image":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#primaryimage"},"thumbnailUrl":"https:\/\/www.credativ.de\/wp-content\/uploads\/2020\/01\/Debian-Integration-von-Patroni-und-vip-manager-Header.jpg","keywords":["Debian","Patroni","PostgreSQL\u00ae"],"articleSection":["HowTos","PostgreSQL\u00ae"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#respond"]}],"copyrightYear":"2020","copyrightHolder":{"@id":"https:\/\/www.credativ.de\/#organization"}},{"@type":"WebPage","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/","url":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/","name":"Debian integration of Patroni and vip-manager - credativ\u00ae","isPartOf":{"@id":"https:\/\/www.credativ.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#primaryimage"},"image":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#primaryimage"},"thumbnailUrl":"https:\/\/www.credativ.de\/wp-content\/uploads\/2020\/01\/Debian-Integration-von-Patroni-und-vip-manager-Header.jpg","datePublished":"2020-01-14T08:35:08+00:00","dateModified":"2022-03-28T15:36:16+00:00","description":"Patroni is a cluster solution for PostgreSQL\u00ae that is becoming increasingly popular, especially in the cloud and Kubernetes environments.","breadcrumb":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#primaryimage","url":"https:\/\/www.credativ.de\/wp-content\/uploads\/2020\/01\/Debian-Integration-von-Patroni-und-vip-manager-Header.jpg","contentUrl":"https:\/\/www.credativ.de\/wp-content\/uploads\/2020\/01\/Debian-Integration-von-Patroni-und-vip-manager-Header.jpg","width":2500,"height":300,"caption":"Debian-Integration von Patroni und vip-manager Header"},{"@type":"BreadcrumbList","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.credativ.de\/en\/"},{"@type":"ListItem","position":2,"name":"Debian integration of Patroni and vip-manager"}]},{"@type":"WebSite","@id":"https:\/\/www.credativ.de\/en\/#website","url":"https:\/\/www.credativ.de\/en\/","name":"credativ GmbH","description":"","publisher":{"@id":"https:\/\/www.credativ.de\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.credativ.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Organization","Place"],"@id":"https:\/\/www.credativ.de\/en\/#organization","name":"credativ\u00ae","url":"https:\/\/www.credativ.de\/en\/","logo":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#local-main-organization-logo"},"image":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#local-main-organization-logo"},"sameAs":["https:\/\/www.facebook.com\/credativDE\/","https:\/\/x.com\/credativde","https:\/\/mastodon.social\/@credativde","https:\/\/www.linkedin.com\/company\/credativ-gmbh","https:\/\/www.instagram.com\/credativ\/"],"description":"Die credativ GmbH ist ein f\u00fchrendes, auf Open Source Software spezialisiertes IT-Dienstleistungs- und Beratungsunternehmen. Wir bieten umfassende und professionelle Services, von Beratung und Infrastruktur-Betrieb \u00fcber 24\/7 Support bis hin zu individuellen L\u00f6sungen und Schulungen. Unser Fokus liegt auf dem ganzheitlichen Management von gesch\u00e4ftskritischen Open-Source-Systemen, darunter Betriebssysteme (z.B. Linux), Datenbanken (z.B. PostgreSQL), Konfigurationsmanagement (z.B. Ansible, Puppet) und Virtualisierung. Als engagierter Teil der Open-Source-Community unterst\u00fctzen wir unsere Kunden dabei, die Vorteile freier Software sicher, stabil und effizient in ihrer IT-Umgebung zu nutzen.","legalName":"credativ GmbH","foundingDate":"2025-03-01","duns":"316387060","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"},"address":{"@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#local-main-place-address"},"geo":{"@type":"GeoCoordinates","latitude":"51.1732374","longitude":"6.392010099999999"},"telephone":["+4921619174200","08002733284"],"contactPoint":{"@type":"ContactPoint","telephone":"08002733284","email":"vertrieb@credativ.de"},"openingHoursSpecification":[{"@type":"OpeningHoursSpecification","dayOfWeek":["Monday","Tuesday","Wednesday","Thursday","Friday"],"opens":"09:00","closes":"17:00"},{"@type":"OpeningHoursSpecification","dayOfWeek":["Saturday","Sunday"],"opens":"00:00","closes":"00:00"}],"email":"info@credativ.de","areaServed":"D-A-CH","vatID":"DE452151696"},{"@type":"Person","@id":"https:\/\/www.credativ.de\/en\/#\/schema\/person\/038c79105ce9b5fd885631da3f806698","name":"Michael Banck","description":"Michael Banck ist seit 2009 Mitarbeiter der credativ GmbH, sowie seit 2001 Mitglied des Debian Projekts und auch in weiteren Open Source Projekten aktiv. Als Mitglied des Datenbank-Teams von credativ hat er in den letzten Jahren verschiedene Kunden bei der L\u00f6sung von Problemen mit und dem t\u00e4glichen Betrieb von PostgreSQL\u00ae, sowie bei der Einf\u00fchrung von Hochverf\u00fcgbarkeits-L\u00f6sungen im Bereich Datenbanken unterst\u00fctzt und beraten."},{"@type":"PostalAddress","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#local-main-place-address","streetAddress":"Hennes-Weisweiler-Allee 23","addressLocality":"M\u00f6nchengladbach","postalCode":"41179","addressRegion":"Deutschland","addressCountry":"DE"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.credativ.de\/en\/blog\/postgresql\/debian-integration-of-patroni-and-vip-manager\/#local-main-organization-logo","url":"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/04\/credativ-logo-right.svg","contentUrl":"https:\/\/www.credativ.de\/wp-content\/uploads\/2025\/04\/credativ-logo-right.svg","caption":"credativ\u00ae"}]},"geo.placename":"M\u00f6nchengladbach","geo.position":{"lat":"51.1732374","long":"6.392010099999999"},"geo.region":"Germany"},"_links":{"self":[{"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/posts\/6713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/comments?post=6713"}],"version-history":[{"count":0,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/posts\/6713\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/media\/4083"}],"wp:attachment":[{"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/media?parent=6713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/categories?post=6713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.credativ.de\/en\/wp-json\/wp\/v2\/tags?post=6713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}