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

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.

Yours,
Laurenz Albe