Re: Re. Postgres Upgrade.

On 9/6/20 2:12 PM, Sushil Shirodkar wrote:

P {margin-top:0;margin-bottom:0;}

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.)