Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wdsHv-004PAG-14 for pgsql-admin@arkaria.postgresql.org; Sun, 28 Jun 2026 16:23:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wdsHt-00Gf2p-1N for pgsql-admin@arkaria.postgresql.org; Sun, 28 Jun 2026 16:23:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wdsHt-00Gf2g-04 for pgsql-admin@lists.postgresql.org; Sun, 28 Jun 2026 16:23:17 +0000 Received: from mail-lj1-x236.google.com ([2a00:1450:4864:20::236]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wdsHq-00000000e9y-0hYT for pgsql-admin@lists.postgresql.org; Sun, 28 Jun 2026 16:23:16 +0000 Received: by mail-lj1-x236.google.com with SMTP id 38308e7fff4ca-39ae3c76ee6so11052821fa.2 for ; Sun, 28 Jun 2026 09:23:13 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782663792; cv=none; d=google.com; s=arc-20260327; b=T7o7aJzotG278tmKe8p/yKwYfnzyJcD3jP0IhCQ3mPg3lnGJaYiysHq3UlnmZANnVv YiofQgUp1qZ5lfycxJ6h8d+Cqxnjci0ywZbo8+7skbdrSRwJwZCTPjx6eez39TKViDm5 ofM85hUkRjl9izKFyVKB4UQ5MyGExX5C/GUXgxkiiKfAzBuNdxvhbbixRHgWhI1iEWSY USKfMHlD3OXTJM+ukK/4EOaXNcUeQd3S1zCh6K65w2106tMyIWT6dFPViMBeEZ2CrUXc rTd4mblwjn2mgO3ki7BGe5QKpNv5S255ml49NdbehZRj9CvpQAUxpQ0v9oWQLJvhRqwY /0CQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=0h2RjJMkaS0MArEZL9FFrHCE6c8/mbLm8O9oBZfIGcU=; fh=druxZHa2fk4e6MLibibygn9AWWgeaAPo4m8Gpo2MBXU=; b=Oiv3PQ5dlctSZriI64lQhBmSAlwFzwbxQc8+K/fCBputSJEaFsSb2jIvAzsY74AGlg pu7sgVFtYSniU/WWPbUe8/S3PYp9lcZcVIoEB6GgFDW6lTVJOyy3p4PJiIbcpMJ560ba zqRh9+zPIghfwLgqWuk1IlfHTjL3atUG4oQxXUV6EzjWSp51dg6n+ck8SSnnP6qB2Sz4 bJirX+BXK8zH1WFss0TIONNjdEWm8fUBr4NdipnFA7pr4jaiMyfMOVbyFj4OQS5Zd8D1 CzHw4mqOzIw+XfERPNxqZOJRmv9rMuhDyTZ+v1/R54CW0HxopyJxFbUKBTPwquGvKnAi tJnA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1782663792; x=1783268592; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=0h2RjJMkaS0MArEZL9FFrHCE6c8/mbLm8O9oBZfIGcU=; b=scQqhvv0PwAAGsu+MEDeOOeyqI/1EkPV6cEi7b+jjn5uNAAcLLyEhM4g7lVWUOphVT QyWHCFsAP83fT3zSt37eLCpixlI+n1eben7XVHVR9Xp7ccT7rbtQEl1Daw8zKrYsS/l1 bqgf5pwFMIhgbyV9NwyP8uW+7ey88Z5nYNUrtB7HgYFlan6RbWnE7vgEKM2OVNra5Chb 5tCPbotMtNj+mzWg8RlCBpwnBHLzWVD6MN/N0G7LzxF3ZR9pON72vEnEwxL8rCepdiOc FjBcQcqlal82J9WPA8reUi41eQt2G4O+po7jAoyXQx6x4/yy+2Z/WXupbGPx67hg1S1j 4qoQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782663792; x=1783268592; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=0h2RjJMkaS0MArEZL9FFrHCE6c8/mbLm8O9oBZfIGcU=; b=gVz6kbzoSA1VK8NEroIO1PHV+pOThkdcTXkwIV/9OivjOd/Bpb3VU40ldq819S61KU OJ8/KCmzaTBSgV7ouOn35hSq8NrkIeaMiC2YubeTWs83KqpJunGfLQwDwzpRivieZI3X 9DwTKdfXvVKdwsjjK4CLAu8Cvvqy9hJzRINj6hrAa76Fr2IOGRa17CIJrJ+HX7mdOlws hLsu2jBbfYEpzfjWPyGHIT8VxYkf/w8DR+6g9BJEoSOQ5H1Zl2jQA0XMhanOcIRKr40S gTNrzPX8folcEN6sOzusIxUbAvvBH3km5bfXgOKq725+v0F55yErpNl9kwjdJUHY3RMn IiUg== X-Gm-Message-State: AOJu0YyTwazlgus8D92z00kRaAxJNVya8q0pXqnuWed5+vbYaU92IQru wxXAxLAKzFYxeNQIgbaAgiEUA9+0ht462Q6pNAWlnOFlry6LvjC+zdWhLgwdpZecxGiLoYixbbl 3EJhT+mYsnecdOI/KMMSRd3kwhj1eOhrTYQ== X-Gm-Gg: AfdE7cmOzvVKSe3rBlYvb0HOvtRi5AGgPkTJUuLGr61iyWSQejj4aozXolUdJsl0jEG UXpLd42yZvbodLNpKztpVJzV5+sCmocfCwNkUj36FfChHEH5h2O0r4MTWbgltRWJoqwj3Bgtgge 1mI//ZLBfUCfCR6Y3N7mdKXaA/4kKRWXWSLSrOZlVsDDVuzUeT58rYH5u7oycL7dVJ1ccw9+rUm fIb4VJ8XV3lLGClPz+HlcKgNK+jDB61VO3Az87pplnCyDTqzYfkRNx0DspDrffMIdQq8dKGItvX aUUg96oRyRdokShi8nLWeX3ZqvYhLH4= X-Received: by 2002:a05:651c:1468:b0:39a:f61f:527e with SMTP id 38308e7fff4ca-39af61f57d6mr10408271fa.18.1782663791914; Sun, 28 Jun 2026 09:23:11 -0700 (PDT) MIME-Version: 1.0 From: Raj Date: Sun, 28 Jun 2026 21:53:00 +0530 X-Gm-Features: AVVi8Cf1YD0mNhUzNhawl8hAbA3uosoUcAs9ckWWVplbicvqlQn7T1JHMUqwXTQ Message-ID: Subject: Major upgrade in patroni cluster To: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000012310c065552c2e0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000012310c065552c2e0 Content-Type: text/plain; charset="UTF-8" Hi All, I have a three node PATRONI cluster with postgres 17.10 version with PGBACKREST, pgnouncer and haproxy. We would like to upgrade postgres 18.4 version. What are the high level steps with minimal downtime? Though I did some research already, would like to understand how it's been followed. --00000000000012310c065552c2e0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi All,

I ha= ve a three node PATRONI cluster with postgres 17.10 version with PGBACKREST= , pgnouncer and haproxy.=C2=A0

We would like to upgrade postgres 18.4 version.=C2=A0

What are the high level steps with mi= nimal downtime? Though I did some research already, would like to understan= d how it's been followed.
--00000000000012310c065552c2e0--