From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Re. Postgres Upgrade.
Date: Sun, 6 Sep 2020 15:55:39 -0500
Message-ID: <4cf6d54d-3718-a504-cb52-1053f761bb4d@gmail.com> (raw)
In-Reply-To: <MN2PR12MB420816528ED788EC7972BF41D42B0@MN2PR12MB4208.namprd12.prod.outlook.com>
References: <MN2PR12MB420816528ED788EC7972BF41D42B0@MN2PR12MB4208.namprd12.prod.outlook.com>
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.)
> 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.)
--
Angular momentum makes the world go 'round.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Re. Postgres Upgrade.
In-Reply-To: <4cf6d54d-3718-a504-cb52-1053f761bb4d@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox