Date: Sat, 11 Oct 2025 14:50:16 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: "Vu Le (JData - HN)" <dba4@jprotech.com.vn>,
	pgsql-general@lists.postgresql.org
Subject: Re: Upgrade & Rollback plan: =?utf-8?Q?My_?=
 =?utf-8?Q?customer_requests_rollback_via_old-version_standby_=2813_?=
 =?utf-8?B?4oaUIDE3KSDigJQ=?= need community advice
Message-ID: <aOqm6FaDpWsOSCyo@momjian.us>
References: <CACT9sogdbwVqsXQeT-V8GP+GhhQrQcwmCPOCTtaPL35jHg5UXQ@mail.gmail.com>
 <8b4a6869b1fca2d0c39777b76439e6f153ba8c76.camel@cybertec.at>
 <CACT9sojZgGUtpm64dqdAf5pRrBgxxsweMcR7mZFmmnoOjoRApw@mail.gmail.com>
 <cae2772d1d0d441aa48ac410409c83d64f1d3ede.camel@cybertec.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <cae2772d1d0d441aa48ac410409c83d64f1d3ede.camel@cybertec.at>
Archived-At: <https://www.postgresql.org/message-id/aOqm6FaDpWsOSCyo%40momjian.us>
Precedence: bulk

On Sat, Oct 11, 2025 at 08:16:42PM +0200, Laurenz Albe wrote:
> On Sat, 2025-10-11 at 23:02 +0700, Vu Le (JData - HN) wrote:
> > If possible, could you please share any additional best practices or
> > important considerations apart from testing the new version in a
> > staging environment?
> 
> All I can think of is:
> 
> - Always keep a backup around.
> 
> - Read the "Migration to version x" section of the release notes of v14,
>   v15, v16 and v17 before you test the application.  That will give you
>   ideas what areas to test particularly well.
> 
> - Test your administrative procedures too.  For example, v15 removed
>   the exclusive online file system backup.

Agreed, and this might help for reviewing the release notes:

	https://momjian.us/main/blogs/pgblog/2022.html#June_13_2022

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.