Re: Safest pgupgrade jump distance

On 2024-02-12 20:07, Dávid Suchan 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, I have tested the process on 9,6 to 10 yet. Would that be a wise
> approach to such an upgrade of the db?
> Also, when upgrading a very big database with replication where none of
> the
> data can be allowed to be lost, is the pgupgrade into rsync approach
> the
> best one? Thanks.

pgupgrade from 9.6 directly to 16 should work fine. That's part of the
test suite for one of my side projects (pgautoupgrade in Docker).

You'll probably want to use the "--link" option too, so it uses the
existing
data files rather than recreating them. It's *much* faster. :)

I'm not sure how the rsync of things will figure into it though. If
you're
just rsyncing files when the database is turned off, it should be
straight
forward.

As always though, make sure you have a backup (that's known to work)
before
you try it all out though. :)

+ Justin