On Mon, Feb 12, 2024 at 5:08 AM Dávid Suchan <david.suchan...@gmail.com> wrote:
> Hi, I was wondering what is the safest pg_upgrade version upgrade distance > going from 9.6 version. Do I need to go version by version or I can go from > 9.6 to 15? We have a very huge database(TBs) with one replication server, > so we will first run the pgupgrade on the main server and then rsync to a > standby replica. I'm not sure whether it's safe to do it from 9.6 to 15 at > once https://www.postgresql.org/docs/16/pgupgrade.html "pg_upgrade supports upgrades from 9.2.X and later to the current major release of PostgreSQL, including snapshot and beta releases."
