Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3696.120.41.1.1\))
Subject: Re: Postgresql community edition upgrade
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CAJuN1jj_QZTSwdHmA3SFC84EpXLm5mEC3awpg5PQaemY8CWB5Q@mail.gmail.com>
Date: Thu, 13 Oct 2022 06:51:53 -0600
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <3DEF677C-D70F-43F5-A912-4DA0C8C949D3@elevated-dev.com>
References: 
 <CAJuN1jj9=x5FPUypuCGntG82mbZQbW-XOWgbg+H97MrwZ20wLA@mail.gmail.com>
 <7ce8278e-f943-74d4-ca73-cbf9e422f784@jakobs.com>
 <CAJuN1jiQ+nUMkay00SSS-axrOBrCL4QoYhRp6sWWdS_S4OHwRg@mail.gmail.com>
 <9571D051-5B4F-45FB-A52B-9D84C601B7DC@elevated-dev.com>
 <183cdeb4338.2923.9bfe8bcc586ac955e423c0e3d5444448@pscs.co.uk>
 <CAJuN1jj_QZTSwdHmA3SFC84EpXLm5mEC3awpg5PQaemY8CWB5Q@mail.gmail.com>
To: Ebin Jozer <ebinjozer@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/3DEF677C-D70F-43F5-A912-4DA0C8C949D3%40elevated-dev.com>
Precedence: bulk

> On Oct 13, 2022, at 3:42 AM, Ebin Jozer <ebinjozer@gmail.com> wrote:
>=20
> We have master and slave environment. So for upgrade we have upgrade =
first in slave and then in master environment. Please confirm

Depends on your HA requirements.

Easiest: shut down primary and all db access, upgrade one, bring it back =
up as primary, upgrade other and bring it back online as replica.

Harder: use a replication scheme that works across versions =
(publish/subscribe, pglogical, londiste, bucardo) so that you can bring =
up a new replica on the new version, switch over to it with minimal =
downtime (just enough to make sure changes from master have been =
replicated), then turn the former primary into a new  replica.=