Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting
 Up Streaming Replication
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CAD=40Z3prwhLAedetocCu3jFvHSBP44V6O9d6CXjvzLTw7eOUQ@mail.gmail.com>
Date: Sun, 24 Nov 2024 09:04:03 -0800
Cc: Adrian Klaver <adrian.klaver@aklaver.com>,
 pgsql-general@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <B252D4B3-C9E2-4C19-93FC-DB4E8FD23B41@thebuild.com>
References: <CAD=40Z3Rvbx46SxYBBdLvgSObXCP+Firszz++rDTXmGX795D2Q@mail.gmail.com>
 <6c498f0e-64f9-449a-9b90-5cd72d00e2ef@aklaver.com>
 <CAD=40Z1wJ7mBej9=Yqfo_1m-eOV61E=s6yDjZSaTBESbGunBUA@mail.gmail.com>
 <2a7d96ac-83a7-4ddc-a3ce-9c637f2c1c76@aklaver.com>
 <CAD=40Z3prwhLAedetocCu3jFvHSBP44V6O9d6CXjvzLTw7eOUQ@mail.gmail.com>
To: Subhash Udata <subhashudata@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/B252D4B3-C9E2-4C19-93FC-DB4E8FD23B41%40thebuild.com>
Precedence: bulk


> On Nov 24, 2024, at 08:51, Subhash Udata <subhashudata@gmail.com> =
wrote:
> However, my concern lies in the fact that we are working with =
production servers, where downtime is not acceptable.

There is no way to upgrade community PostgreSQL, either to a new minor =
version or a new major version, with absolute zero downtime.

To do a minor version upgrade such as this, the only thing that is =
required is to restart the server with the new binaries.  While this =
does require a service interruption, it's quite short, and is not =
significantly longer than the interruption required to do a failover.  =
You can do the primary and secondary in either order, although upgrading =
the primary first is probably the safest route.  You don't have to =
switch the primary / secondary roles in this case, nor rebuild the =
secondary server using pg_basebackup.=