Re: Re. Postgres Upgrade.

[Sushil Shirodkar <sushilps@xxxxxxxxxxx>]

---

From: Ron <ronljohnsonjr@xxxxxxxxx>
Sent: Sunday, September 6, 2020 4:55 PM
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: 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.)

We already have them on new server. 

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

Okay, sounds good. Thanks Ron. 

--
Angular momentum makes the world go 'round.