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

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

Hi Shyamkant,

> On 07. Sep, 2020, at 07:05, shyamkant.dhamke@wipro.com wrote:
>
> Hello,
> Please un-subscribe my email from emailing list. Thanks.
>
> Regards
> Shyamkant


please go to https://www.postgresql.org/account/login/ and manage your list subscriptions there.

Cheers,
Paul