Postgres Pro
Downloads
Home   >   mailing lists

Re: Safest pgupgrade jump distance - Mailing list pgsql-general

From Ron Johnson
Subject Re: Safest pgupgrade jump distance
Date
Msg-id CANzqJaB2dL=ijCqqWKfKzFktzKjfdGR8thk9q5vgYhNp9sybTA@mail.gmail.com
Whole thread Raw
In response to Safest pgupgrade jump distance  (Dávid Suchan <david.suchan.ds@gmail.com>)
Responses Re: Safest pgupgrade jump distance
List pgsql-general
Tree view
On Mon, Feb 12, 2024 at 5:08 AM Dávid Suchan <david.suchan.ds@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

"pg_upgrade supports upgrades from 9.2.X and later to the current major release of PostgreSQL, including snapshot and beta releases."
 

pgsql-general by date:

Previous
From: Johnathan Tiamoh
Date:
Subject: Re: Safest pgupgrade jump distance
Next
From: Karsten Hilbert
Date:
Subject: Re: Safest pgupgrade jump distance