Docs: Refactor upgrade guidance with regards to Postgres major version upgrade

• Start this issue's title with Docs: or Docs feedback:.

Problem to solve

Existing upgrade docs do not clarify details for PG version upgrade. It highly depends on customer environment configuration.

Proposal

Please see !208497 (comment 2813605106)

Who can address the issue

Other links/references