Re: Re. Postgres Upgrade.

On 9/6/20 2:12 PM, Sushil Shirodkar wrote:
> Hello experts,
>
>
> Looking for advise/suggestions on the following scenario.
>
> Existing Setup        Moving to
>
> Postgres => 10.5           Postgres => 12.4
> Ubuntu   => 16.04.5     Ubuntu   => 20.04.1
>
> Question:
> We have new environment ready with PG 10 & PG 12 with Ubuntu 20.
>
> To reduce the upgrade time, can I bring the volume(10/main) from old
> server to new server & connect to PG10 and do the pg_upgrade ?

What about the binaries?  (Though you can install PG 10 binaries for Ubuntu
20.04 easily enough.)

> will
> PG10 running on "Ubuntu 16" work on "Ubuntu 20" for upgrade to PG12 ?
> or I have to go thru pg_dumpall route.

You could copy the volumes over and pg_upgrade, do a pg_dumpall or enable
logical replication from one to another.  (That would greatly minimize
downtime.)

--
Angular momentum makes the world go 'round.