RE: Re. Postgres Upgrade.

"shyamkant.dhamke@xxxxxxxxx" <shyamkant.dhamke@xxxxxxxxx> · Mon, 7 Sep 2020 05:05:24 +0000

Hello,
Please un-subscribe my email from emailing list. Thanks.

Regards
Shyamkant

From: Sushil Shirodkar <sushilps@xxxxxxxxxxx>

Sent: 07 September 2020 00:43

To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx

Subject: Re. Postgres Upgrade.

** This mail has been sent from an external source. Treat hyperlinks and attachments in this email with caution**

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 ? will

PG10 running on "Ubuntu 16" work on "Ubuntu 20" for upgrade to PG12 ?

or I have to go thru pg_dumpall route. 

Thanks in advance, 

Rgs,

Sushil 

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should
 not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments
 for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com