Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice

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 AM Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>
> 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(at)momjian(dot)us> https://momjian.us
> EDB https://enterprisedb.com
>
> Do not let urgent matters crowd out time for investment in the future.