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.94.2) (envelope-from ) id 1tTd64-00744x-Ll for pgsql-admin@arkaria.postgresql.org; Fri, 03 Jan 2025 08:31:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tTd63-007nIO-MI for pgsql-admin@arkaria.postgresql.org; Fri, 03 Jan 2025 08:31:55 +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.94.2) (envelope-from ) id 1tTd63-007nEr-6b for pgsql-admin@lists.postgresql.org; Fri, 03 Jan 2025 08:31:54 +0000 Received: from mail-oa1-x2d.google.com ([2001:4860:4864:20::2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tTd60-002xhp-3G for pgsql-admin@lists.postgresql.org; Fri, 03 Jan 2025 08:31:54 +0000 Received: by mail-oa1-x2d.google.com with SMTP id 586e51a60fabf-29e842cb9b4so3713527fac.2 for ; Fri, 03 Jan 2025 00:31:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1735893110; x=1736497910; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=EiOqZeoWT/8EqZ899juiQE4mgcXZC+zk5Srd5j2C0Lo=; b=E+Pp/9pXVeE5HOc3Fy6fPn0z0GwMQ27VeXXJz6LVguNv6PyZtmwZ51ZLmPAZPn1oNg Ss+IXoLJ+w2xgTvbUB5L2Tnb6+0Ee4FfTA5emxbvDlwsD7YvPRhs1bzY7DPgIbXqCKAb Cnfctuw5wADoaoAu7KqIKN/YfuiCwADh3m3Ach2bGTGtt5hxI1pq7SR/Y+KSkcenM+eA jiEUXg68Di44WI3c4uixpL9CeXZc5TFgqf/XECmbE3nsFgnNZKgwxr4wjeF5//0nFxIT 2JPsGuo8MaBGcuIaVytbgU5Ww8TrFeNdYedeoTIu/ZGNH4mJVk24dpC/F08JUMAQjZva v/eg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1735893110; x=1736497910; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=EiOqZeoWT/8EqZ899juiQE4mgcXZC+zk5Srd5j2C0Lo=; b=S0UheduJMWgkOVfsN7B9P/u1aajvSQb18p9555k58tesf4d+BJeAbV+27ZDwZAi9rA MYJ3psuH4qFe1E6aHKsTZALR2SOUpkW+jIeWInn1fCuKFDhImUzsfuuRK0RNM9M3X6yZ CzUFC7D3nMs228DSfrBZyffxl5eg2U2RZmFngY3jCrP3fsQhw6XUF3nyW8379gDJ7fYw selNAUTNL8P0YPBP4Z8qNKdYcZDvGZbB5rZICwT4dVQscRr7yeaaYYbE4xnwQsmZZCYL F/Mj1sSj/EVnldnvEH9TyuiHptkF0z27NmygcHA4IforPoLWfMqGhT0Sy4v8kclNLG+c /RxA== X-Gm-Message-State: AOJu0YwNGycPU/ToO4Jl1fzmBc47D7/uLLV/jznFl6nOgkP9x9G3uppL u7lBeKPM9iM33PsPBVOO3GSCSHgzTVVy9BSMff4R8T811lAhpl8eq+gIlgYOB381KCI1rTHELPK XWv71G3M1fr1d3kEGz5Pij8OPAXZY4g== X-Gm-Gg: ASbGncv9AlRIHh+QVNcLNNj3Vs4vrIbg9ecXmyz7fg+QZmlPNqMGDo+JeXIfTxaVylL dWftAbRMHSfClk7QtfO3A3k2sjbov7WIj1ChEa+dDiHqLrqL1J5DmW+Af0XK0ZvXFmbSaDO0d X-Google-Smtp-Source: AGHT+IFDTG51GkCNu2kTj05DSvA9QKH4rkUe4JMyPTu2xX1TPYNdbo8+znRoWkewri8bbzPEoFrlUIyyNVWCQ5+OPIE= X-Received: by 2002:a05:6870:2f0f:b0:259:88b4:976 with SMTP id 586e51a60fabf-2a7fb47541bmr22546600fac.43.1735893109978; Fri, 03 Jan 2025 00:31:49 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Fri, 3 Jan 2025 03:31:39 -0500 Message-ID: Subject: Re: Upgrade for primary standby config To: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000030472d062ac91c0d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000030472d062ac91c0d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Jan 3, 2025 at 3:21=E2=80=AFAM Laurenz Albe wrote: > On Fri, 2025-01-03 at 06:21 +0530, Siddhartha Jain wrote: > > Please provide me with the high level steps for upgrade in postgres fro= m > 11 to 15 version > > for primary-standby configuration setup. > > You cannot use a streaming replication standby server; you have to use > logical replication. > Or does OP mean that he wants to upgrade both the primary and replica at the same time? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --00000000000030472d062ac91c0d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, Jan 3, 2025 at 3:21=E2=80=AFAM La= urenz Albe <laurenz.albe@cyb= ertec.at> wrote:
On Fri, 2025-01-03 at = 06:21 +0530, Siddhartha Jain wrote:
> Please provide me with the high level steps for upgrade in postgres fr= om 11 to 15 version
> for primary-standby configuration setup.

You cannot use a streaming replication standby server; you have to use logi= cal replication.

Or does OP mean that h= e wants to upgrade both the primary and replica at the same time?

--
Death to <Redacte= d>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
--00000000000030472d062ac91c0d--