pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe. Postgres Upgrade.
5+ messages / 4 participants
[nested] [flat]
* Re. Postgres Upgrade.
@ 2020-09-06 19:12 Sushil Shirodkar <sushilps@hotmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Sushil Shirodkar @ 2020-09-06 19:12 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Re. Postgres Upgrade.
@ 2020-09-06 20:55 Ron <ronljohnsonjr@gmail.com>
parent: Sushil Shirodkar <sushilps@hotmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Ron @ 2020-09-06 20:55 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Re. Postgres Upgrade.
@ 2020-09-06 21:11 Sushil Shirodkar <sushilps@hotmail.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Sushil Shirodkar @ 2020-09-06 21:11 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
________________________________
From: Ron <ronljohnsonjr@gmail.com>
Sent: Sunday, September 6, 2020 4:55 PM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Re. Postgres Upgrade.
@ 2020-09-07 05:05 shyamkant.dhamke@wipro.com <shyamkant.dhamke@wipro.com>
parent: Sushil Shirodkar <sushilps@hotmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: shyamkant.dhamke@wipro.com @ 2020-09-07 05:05 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hello,
Please un-subscribe my email from emailing list. Thanks.
Regards
Shyamkant
From: Sushil Shirodkar <sushilps@hotmail.com>
Sent: 07 September 2020 00:43
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Re. Postgres Upgrade.
@ 2020-09-07 05:49 Paul Förster <paul.foerster@gmail.com>
parent: shyamkant.dhamke@wipro.com <shyamkant.dhamke@wipro.com>
0 siblings, 0 replies; 5+ messages in thread
From: Paul Förster @ 2020-09-07 05:49 UTC (permalink / raw)
To: shyamkant.dhamke@wipro.com; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2020-09-07 05:49 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-09-06 19:12 Re. Postgres Upgrade. Sushil Shirodkar <sushilps@hotmail.com>
2020-09-06 20:55 ` Ron <ronljohnsonjr@gmail.com>
2020-09-06 21:11 ` Sushil Shirodkar <sushilps@hotmail.com>
2020-09-07 05:05 ` shyamkant.dhamke@wipro.com <shyamkant.dhamke@wipro.com>
2020-09-07 05:49 ` Paul Förster <paul.foerster@gmail.com>
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