Re: Guidance Needed for PostgreSQL Upgrade from 12 to 15

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Kris Deugau <kdeugau(at)vianet(dot)ca>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Guidance Needed for PostgreSQL Upgrade from 12 to 15
Date: 2024-11-19 17:42:42
Message-ID: 39901423-2003-493F-8A5C-12D1B1062F00@elevated-dev.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Nov 19, 2024, at 10:32 AM, Kris Deugau <kdeugau(at)vianet(dot)ca> wrote:
>
> as otherwise the old PG won't start properly, due to the changes made by pg_upgrade.

Not true, pg_upgrade leaves it in a state where either can be started. By taking the snapshot after, if you roll back to it, you can attempt changes on either the old or new. (Taking care to take additional snapshots as needed, to preserve the ability to roll back to this state.)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kris Deugau 2024-11-19 20:40:51 Re: Guidance Needed for PostgreSQL Upgrade from 12 to 15
Previous Message Kris Deugau 2024-11-19 17:32:29 Re: Guidance Needed for PostgreSQL Upgrade from 12 to 15