Re. Postgres Upgrade.

From: Sushil Shirodkar <sushilps(at)hotmail(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re. Postgres Upgrade.
Date: 2020-09-06 19:12:57
Message-ID: MN2PR12MB420816528ED788EC7972BF41D42B0@MN2PR12MB4208.namprd12.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2020-09-06 20:55:39 Re: Re. Postgres Upgrade.
Previous Message Achilleas Mantzios 2020-09-04 09:17:37 Re: Postgres Replication on a different network interface