Re: Upgrade from PostgreSQL 9.6 to 11

Thanks all,

Is pg_upgrade is the best method if I am doing upgrade on same server or
different server.

Same server means: source and Target on same server

Different: source and Target are different server.

On Mon, Jun 10, 2019, 12:07 PM Michael Paquier <michael(at)paquier(dot)xyz> wrote:

> On Mon, Jun 10, 2019 at 09:00:38AM +0300, Achilleas Mantzios wrote:
> > On 10/6/19 7:36 π.μ., Pawan Sharma wrote:
> >> What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL
> >> 11 instead of pg_upgrade.
> >
> > why not pg_upgrade ? If the size is near the 3TB mark as you say,
> > pg_upgrade is the fastest IMHO.
>
> When it comes to upgrades, you could also look at logical
> replication. Unfortunately your origin version cannot do that. Have
> you looked at things like BDR or Slony? They are logical-based,
> meaning a lower downtime than pg_upgrade, but they take longer.
>
> For 3TB pg_upgrade can also be very fast if you use --link. Be wary
> of having backups though, all the time.
> --
> Michael
>