MIME-Version: 1.0
References: <CACT9sogdbwVqsXQeT-V8GP+GhhQrQcwmCPOCTtaPL35jHg5UXQ@mail.gmail.com>
 <8b4a6869b1fca2d0c39777b76439e6f153ba8c76.camel@cybertec.at>
 <CACT9sojZgGUtpm64dqdAf5pRrBgxxsweMcR7mZFmmnoOjoRApw@mail.gmail.com>
 <cae2772d1d0d441aa48ac410409c83d64f1d3ede.camel@cybertec.at> <aOqm6FaDpWsOSCyo@momjian.us>
In-Reply-To: <aOqm6FaDpWsOSCyo@momjian.us>
From: "Vu Le (JData - HN)" <dba4@jprotech.com.vn>
Date: Sun, 12 Oct 2025 07:37:57 +0700
Message-ID: <CACT9sohKTtS4h10XJL6p2vyo=JN3XAvYXavMGFrZDeedQS4weA@mail.gmail.com>
Subject: =?UTF-8?Q?Re=3A_Upgrade_=26_Rollback_plan=3A_My_customer_requests_ro?=
	=?UTF-8?Q?llback_via_old=2Dversion_standby_=2813_=E2=86=94_17=29_=E2=80=94_need_communit?=
	=?UTF-8?Q?y_advice?=
To: Bruce Momjian <bruce@momjian.us>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CACT9sohKTtS4h10XJL6p2vyo%3DJN3XAvYXavMGFrZDeedQS4weA%40mail.gmail.com>
Precedence: bulk

Dear Bruce and Laurenz,

Thank you very much for taking the time to share your valuable advice with =
me.

The information you provided was highly useful, and I appreciate the
specific guidance.

I intend to dedicate time to research your suggestions further.

I look forward to applying this knowledge. Thank you again for your
time and expertise.

Best regards,
Miles Le | Vu (Mr.)

On Sun, Oct 12, 2025 at 1:50=E2=80=AFAM Bruce Momjian <bruce@momjian.us> wr=
ote:
>
> 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.